Thread: How to convert date to financial year format 2006-07
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default How to convert date to financial year format 2006-07
There may be a simpler way, but you could try
=IF(OR(MONTH(A1)<=3,AND(MONTH(A1)=4,DAY(A1)<=5)),Y EAR(A1)-1,YEAR(A1))&"-"&TEXT(IF(OR(MONTH(A1)<=3,AND(MONTH(A1)=4,DAY(A1)< =5)),A1,DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))),"yy")

This assumes that the financial year boundary is between 5th and 6th of
April; modify the formula accordingly if your financial year runs
differently.
--
David Biddulph

"Yog Raj" <Yog wrote in message
...
How can I conver date to Financial year format i.e 20th March 2006 as
2005-06


Reply With QuoteReply With Quote