Hello,
I want to calculate the no. of working days in a month.
My data looks like this: B2= Feb/2014 and in B3 I would like to have 20 day (working days in that month).
Thank you, in advance!
Hello,
I want to calculate the no. of working days in a month.
My data looks like this: B2= Feb/2014 and in B3 I would like to have 20 day (working days in that month).
Thank you, in advance!
Try:
=NETWORKDAYS(B2,EOMONTH(B2,0))
Quang PT
Try the following:
=NETWORKDAYS(EOMONTH(B2,-1)+1,EOMONTH(B2,0))
As you do not have a day for the Feb date.
Thank you! it worked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks