0

I found this post and it worked for a 4-digit year but I am trying to use a 2-digit year

Calculating Fiscal Year

This will give you the format 2013-2014, 2014-2015:

=IF(MONTH(Created)>6,YEAR(Created)&"-"&YEAR(Created)+1,YEAR(Created)-1&"-"&YEAR(Created))

It takes MONTH>6, so you could adjust that parameter for fiscal start.

And for FY 2014, FY 2015 etc, you could use this formula:

=IF(MONTH(Created)>6,"FY "&YEAR(Created)+1,"FY "&YEAR(Created))

that formula returned 2015.

I tried using the formula TEXT([DateField],”yy”) and nesting it inside the datefield area. it returns 05 for (1905) instead of 15 for 2015

Is there a way to return in the YY format?

  • "it returns 05 for (1905) instead of 15 for 2015" can you be more clear on this? – Keerthi Jun 2 '15 at 21:16
  • After removing the FY text, the formula returned 1/2/1905 instead of the 1/2/2015 based off of the date field selected when viewing the column in a list. When I nested the formula in this formula: TEXT([DateField],”yy”) it gave me the 2--digit year as requested but it was the year (05) instead of the expected year (15) – Mike G Jun 3 '15 at 13:44
1

Try

=IF(MONTH(Date)>6,"FY "&RIGHT(YEAR(Date)+1,2),"FY "&TEXT(Date,"yy"))
  • This worked for me. I removed the "FY" and came to the 2-digit year i was looking for. Thank You – Mike G Jun 3 '15 at 13:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.