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
Bookmarks