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

[Jon Friessen]

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/tutorial...b-7374d3da3425/wpf-and-the-model-view-vi.aspx

 

[Ashish Mathur]

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

in message news:[email protected]...