View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Clanlabcooker Clanlabcooker is offline
external usenet poster
 
Posts: 2
Default Birthdate as fiscal year

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?