The standing formula I use is this =DATE(YEAR(H6)+M6,MONTH(H6),DAY(H6)) which takes the date in field H6, adds the number in field M6 and displays a date in the future i.e 7/9/2018 plus 6 = 07/08/2024
But in some instances I need to do is this instead:
I need to take the date displayed (in A2) add one year and then for the date calculated to always be the 31 March. It's an audit date for finance purposes so in this instance the date 7/8/2018 needs to return a date of 31/03/2025. The formula =DATE(YEAR(A2)+1+E2,MONTH(03),DAY(31)) returns 31/01/2025 so I'm close. Where am I going wrong please?
AuditDateFormulaError.JPG
Bookmarks