In my spreadsheet, I have a column for each month, 8/1/05, 9/1/05,
etc...

What I want to know is, how many paychecks will I receive each month?

I get paid every other week on a Friday.

My first attempt with help from reading other posts was to do this

=(4+(DAY(D1-DAY(D1)+1-WEEKDAY(D1-DAY(D1+5))+35)7))/2

To get the number of fridays, divided by 2. But that returns 2.5 in
some months, and I dont know which of these 4 months each year gets me
the extra paycheck.

Thanks for the help


--
jkh1978
------------------------------------------------------------------------
jkh1978's Profile: http://www.excelforum.com/member.php...o&userid=26461
View this thread: http://www.excelforum.com/showthread...hreadid=397278