Subtract a date for the first of the month

[excelaron]

Hello All, I'm trying to figure out formula to for instance: 3/07/2012 from 3/1/2012. I want to use formula since I have to copy down 400 plus rows.

I'm using the NETWORKDAYS function. but EOMONTH(3/07/2012,0)+1 give me 4/1/2012.

the number of workdays from the first of the month for a given date


Any suggest will be appreciated.

[daddylonglegs]

Try using EOMONTH with -1, so if you have a date in A2 you can get the number of workdays between the start of that month and A2 with this formula

=NETWORKDAYS(EOMONTH(A2,-1)+1,A2)

or you can use this version

=NETWORKDAYS(A2-DAY(A2)+1,A2)

[excelaron]

I got it EOMONTH(03/072012, -1)+1 give me 03/01/2012

---------- Post added at 03:14 PM ---------- Previous post was at 03:13 PM ----------

Thanks daddylonglegs