Calculate date due from variable date to semi-fixed date

wsnow · #1 08-08-2024, 07:08 AM

=IF(ISBLANK([@[Declaration Date]]),"", DATE(YEAR([@[Declaration Date]])+1,MONTH(3),DAY(31)))

I wrote the above to calculate the due date for new applications based on the declaration date on an event. The due date is always 3/31 in the calendar year following the year after the event, no matter what month/day.

The above formula is returning the correct year and day, but no matter what number I put after MONTH, the result is 1/31/XXXX rather than 3/31/XXXX. Excel not returning any error message on formula.

What did I do wrong?

Thanks.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculate due date with variable based on different start dates.	wsnow	Excel	4	04-24-2024 09:38 AM
Calculate date from two variable fields, with no #value error in empty rows	wsnow	Excel	4	09-22-2023 05:55 AM
Use Original Award Date or Mod Award Date For Date-Based Recurring Tasks	KBCasey27	Project	1	04-30-2021 12:22 AM
Calculate a Date	shawn.low@cox.net	Mail Merge	5	12-12-2019 03:22 PM
calculate date if date entered in cell, do nothing if blank	ConfuddledOne	Excel	3	11-07-2014 09:37 AM