dear cute,
please try it, first change ur formar in mm/dd/ format
=NETWORKDAYS(DATEVALUE(MID(B4,FIND("/",B4,1)+1,1)&"/"&LEFT(B4,1)&"/"&RIGHT(B4,4)),TODAY())
On Mon, Aug 27, 2012 at 10:34 PM, Cute Awesome wrote:
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will n