SharePoint: Fiscal year as Calculated column
=IF(MONTH(Created)>2,"FY "&YEAR(Created)+1,"FY "&YEAR(Created))
here Month(Created)>2 can be changed as per business need. I had a scenario to show fiscal year between February of every year
=IF(MONTH(Created)>2,"FY "&YEAR(Created)+1,"FY "&YEAR(Created))
here Month(Created)>2 can be changed as per business need. I had a scenario to show fiscal year between February of every year
Comments
Post a Comment