Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel dilema | Excel Discussion (Misc queries) | |||
IF Dilema detail | Excel Discussion (Misc queries) | |||
IF Dilema | Excel Discussion (Misc queries) | |||
Date Range -- Weekly | Excel Worksheet Functions | |||
sorting dilema | Excel Discussion (Misc queries) |