Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
What is a formula that will allow me to extract 12 month/year combinations
based on a birthdate to start a fiscal year? For example a birthdate of 07/30/1956 would return July 2006, August 2006...June 2007. A birthdate of 05/22/2001 would return May 2006, June 2006...April 2007. I can handle the year by using a reference field for the starting year, but how do I convert the May or July birthmonth into a series of month/year combos that increment the year when rolling over to January? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
holiday dates | Excel Worksheet Functions | |||
How do I get Excel to automatically calculate salaries actually received in financial year? | Excel Discussion (Misc queries) | |||
Fiscal Year in date field | Excel Discussion (Misc queries) | |||
Fiscal Year Calculation | Excel Worksheet Functions | |||
Date formula: return Quarter and Fiscal Year of a date | Excel Discussion (Misc queries) |