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, 09:38 AM

p45cal

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

Office 2021

Expert

Join Date: Apr 2014

Posts: 962

Code:

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

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 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 03:24 PM.