Calculate date due from variable date to semi-fixed date

		Microsoft Office Forums > Microsoft Excel > Excel
Calculate date due from variable date to semi-fixed date

FAQ

Thread Tools

Display Modes

08-08-2024, 12:12 PM

p45cal

Windows 10 Calculate date due from variable date to semi-fixed date

Office 2021

Expert

Join Date: Apr 2014

Posts: 956

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

Re: "no matter what number I put after MONTH"
For silliness, try 65.

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:43 PM.