calculating number of prior pay periods in year when given specificdate.
 

I am trying to calculate the number of bi-weekly and weekly pay periods of a given year.

Example

9/1/09 - there are 35 (weekly) tuesdays before this date, and 18 biweekly periods.

what excel function can I use to do this?

Is there also a way for semi-monthly?

EggHeadCafe - Software Developer Portal of Choice
WPF And The Model View View Model Pattern
http://www.eggheadcafe.com/tutorials...l-view-vi.aspx

calculating number of prior pay periods in year when given specific date.
 

Hi,

Try this. C15 holds 9/1/2009. B15 holds 1/1/2009. The answer would be 35

=SUMPRODUCT(1*(WEEKDAY(ROW(INDIRECT(C15&":"&B15))) =2))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Jon Friessen" wrote in message ...
I am trying to calculate the number of bi-weekly and weekly pay periods of
a given year.

Example

9/1/09 - there are 35 (weekly) tuesdays before this date, and 18 biweekly
periods.

what excel function can I use to do this?

Is there also a way for semi-monthly?

EggHeadCafe - Software Developer Portal of Choice
WPF And The Model View View Model Pattern
http://www.eggheadcafe.com/tutorials...l-view-vi.aspx