| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to convert date to financial year format 2006-07
How can I conver date to Financial year format i.e 20th March 2006 as 2005-06
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to convert date to financial year format 2006-07
Try a custom format of:-
yyyy-mm Mike "Yog Raj" wrote: How can I conver date to Financial year format i.e 20th March 2006 as 2005-06 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to convert date to financial year format 2006-07
You can convert it, you can change the way it is displayed
use custom format yyyy-mm -- Regards, Peo Sjoblom "Yog Raj" <Yog wrote in message ... How can I conver date to Financial year format i.e 20th March 2006 as 2005-06 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to convert date to financial year format 2006-07
I meant to say you can't convert it, the underlying value is the same, but
you can change the way it is displayed -- Regards, Peo Sjoblom "Peo Sjoblom" wrote in message ... You can convert it, you can change the way it is displayed use custom format yyyy-mm -- Regards, Peo Sjoblom "Yog Raj" <Yog wrote in message ... How can I conver date to Financial year format i.e 20th March 2006 as 2005-06 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to compare a date with financial year | Excel Discussion (Misc queries) | |||
| How do I convert a month-date format to day number of the year? | Excel Worksheet Functions | |||
| Convert date format from 20060801 to 1st Aug 2006 (or similar)? | Excel Discussion (Misc queries) | |||
| turn off convert text to date (i.e. 4-9 to April 9, 2006) | Excel Worksheet Functions | |||
| How do I change a date format 3/14/2006 to 3-14-2006 in Excel 2002 | Excel Discussion (Misc queries) | |||
Linear Mode
