View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spongebob Spongebob is offline
external usenet poster
 
Posts: 13
Default Bi-weekly date dilema

I am trying to find a way to have excel recognize a bi-weekly pay period for
a timesheet I am working on, but I have run into a problem. I can easily
have excel count off every other Monday for a few weeks, but how do I tell it
where to start? Our pay periods always change depending on the year. So the
first Monday in September is a pay-day this year, but next year it might fall
on the second Monday in September.

Is there a way to give an example of a 'good' Monday and have excel handle
whether or not it is an increment of 14?

Thanks,
Jeff