Calculate due date with variable based on different start dates.

		Microsoft Office Forums > Microsoft Excel > Excel
Calculate due date with variable based on different start dates.

04-24-2024, 04:03 AM

p45cal

Windows 10 Calculate due date with variable based on different start dates.

Office 2021

Expert

Join Date: Apr 2014

Posts: 956

Code:

=[@[POP End Date]]-IF([@[Declaration Date]]<=DATE(2023,3,22),60,90)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculate date from two variable fields, with no #value error in empty rows	wsnow	Excel	4	09-22-2023 05:55 AM
Calculated Start Dates Based on Pre-scheduled Meetings	lcrevist	Project	1	03-12-2016 10:32 AM
Is this possible? - Calculate and Display the date range between 2 specific dates	Premier-UK	Excel	2	08-18-2014 05:43 AM
Excel to auto populate dates based on start and end	patidallas22	Excel Programming	9	04-21-2014 03:14 PM
MS Project Start Dates not matching the Status Date	sjodom	Project	3	12-04-2011 08:45 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:31 PM.