View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

Nor do we. If you get paid in the final fri of a 4 fri month, you will only
get 2 the following month even if it has 5 fri.

It all depends upon where you start from, only you know that.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"jkh1978" wrote in
message ...

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