Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have been trying to figure out how to work out the first pay period
after a specific date using if paid on a fortnightly basis. The primary function would be to work out the first pay period in the fiscal year and then one would count the number of pay periods. It'll be used to forecast the f/nightly cash flow for a salary budget. The financial year: START: 1st July END: 30 June The history of the first pay periods have been: Thursday, 1 July 2004 Thursday, 14 July 2005 Thursday, 13 July 2006 Thursday, 12 July 2007 Thursday, 10 July 2008 Thursday, 9 July 2009 Without knowing the first pay date, I'm struggling to figure out a way to work it out automatically, so that the template could be used for many years to come without having to manually update the first pay period. Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
calculating periods (yrs, months and days) | New Users to Excel | |||
Calculating number of periods | Excel Worksheet Functions | |||
Calculating Calls closed in Given periods | Excel Worksheet Functions | |||
Calculating overlapping time periods | Excel Worksheet Functions | |||
Calculating overlapping time periods | Excel Worksheet Functions |