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.

FAQ

Thread Tools

Display Modes

04-24-2024, 12:11 AM

Pecoflyer

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

Office 2021

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,943

Pecoflyer has a reputation beyond repute

Try

Code:

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

Otherwise Please post a sample sheet ( no pics please) with some data . Thx

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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