How to calculate a fiscal day of year in Excel?

0
votes

I'm working with Excel. I have a calendar date, fiscal year, fiscal month, fiscal quarter. I need to calculate the day of fiscal year.

Fiscal year starts on April 1st and ends on March 31st.

How can I calculate the day of fiscal year where: 1 Apr = 1, 2 Apr = 2 , .... 31 March = 365.

Is there any formula for this?

1
exceldateexcel-formulaformula
What have you tried and what problems have you run into. It should be a simple subtraction problem. – Ron Rosenfeld
Have a look at Date and time functions. hint: use =EDATE(<DATE>, 4) to adjust the differential. – user4039065
Here is another resource. – Scott Craner

1 Answers

0
votes

If your dates are in ColumnA and you have a cell in the same workbook containing the previous year end, named LastFYend and of workbook scope, then perhaps: 

=TEXT(A1-LastFYend,"0")