| Issue | Date Formula = EDATE(StartDate,-12) I.e. 04/01/07 Start Date, want to see 04/01/06 This formula returning a #REF! and doesn't calculate. If I try EOMONTH(StartDate,-12) it returns 04/30/06 which works but incorrect date. Can you please suggest a date formula (Excel or Jet Reports) to do this? The Report is for a balance sheet. |
| Solution |
=DATE(YEAR(StartDate)-1, MONTH(StartDate), DAY(StartDate)) or =DATE(YEAR(StartDate), MONTH(StartDate) -12, DAY(StartDate)) |
#REF! on Data Formula Field Print
Modified on: Mon, Dec 12, 2016 at 3:26 PM
Did you find it helpful? Yes No
Send feedbackSorry we couldn't be helpful. Help us improve this article with your feedback.