Calculating the Financial Year of a specific date using a calculated column in Sharepoint

[ Antworten ] [ Ihre Antwort ] [ Forum www.einfachbuch.de ]

Abgeschickt von pj am 23 Juni, 2009 um 09:30:26:

Assuming the financial year (AKA business year) would start in October, the formula is:

=IF(MONTH(WhateverDate)<10;"BY"&RIGHT(YEAR(WhateverDate)-1;2)&"/"&RIGHT(YEAR(WhateverDate);2);"BY"&RIGHT(YEAR(WhateverDate);2)&"/"&RIGHT(YEAR(WhateverDate)+1;2))

Example:
If WhateverDate would be equals "1.1.2009", the formula would result in "BY08/09". If date equals "10.10.2009", result is "BY09/10".


Antworten:


Ihre Antwort

Name:
E-Mail:

Subject:

Text:

Optionale URL:
Link Titel:
Optionale Bild-URL:

[ Antworten ] [ Ihre Antwort ] [ Forum www.einfachbuch.de ]