Thread: how do I set a year to commence on date other than January 1
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MPCB MPCB is offline
external usenet poster
  
Posts: 1
Default how do I set a year to commence on date other than January 1
I wnat to compare data between year 1 and year 2 etc. in Excel, and I also
need that the year is Oct to Sept. Is there a formula that will conver a date
into a Year (or period of 12 months) and identify it as year 1 or year 2 etc.
Reply With QuoteReply With Quote