0

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?

Improve this question
3
  • 1
    What have you tried and what problems have you run into. It should be a simple subtraction problem.
    – Ron Rosenfeld
    Commented Dec 5, 2015 at 21:42
  • Have a look at Date and time functions. hint: use =EDATE(<DATE>, 4) to adjust the differential.
    – user4039065
    Commented Dec 5, 2015 at 22:10
  • Here is another resource.
    – Scott Craner
    Commented Dec 5, 2015 at 22:22

1 Answer 1

Reset to default
0

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")
Improve this answer

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