Forum Discussion

DarleneDarlene's avatar
DarleneDarlene
Qrew Member
12 years ago

How do you calculate the Last Day of the Fiscal Year?

Our fiscal year is May 1st through April 30th each year. Based on the "Start Date" of a piece of work, I would like to calculate the last day of the Fiscal Year.

e.g. For Start Date 1-Feb-2013, End of Fiscal year would be 30-Apr-2013, and for Start Date 15-Nov-2013, End of Fiscal Year would be 30-Apr-2014.
Tables and fields

13 Replies

Sort By
Show More
  • GeorgeBramhall2's avatar
    GeorgeBramhall2
    Qrew Cadet
    6 years ago
    and why doesn't this formula work? What "types" of date fields does this formula not work for?

    Month([Last Day of Year (Next Year)]-Month([First Day of Next Year (Bound Date)])
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    Sorry, I am not really understanding your question. You seem to be asking two different questions.