Calculating a due date based on two different starting points.

		Microsoft Office Forums > Microsoft Excel > Excel
Calculating a due date based on two different starting points.

FAQ

Thread Tools

Display Modes

08-18-2024, 06:35 AM

Pecoflyer

Windows 10 Calculating a due date based on two different starting points.

Office 2021

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Perhaps

Code:

=IF(ISBLANK([@[Declaration Date]]),"",IF([@[Declaration Date]]<DATE(2024,8,15),EDATE([@[Declaration Date]],12),EDATE(,[@[Declaration Date]],15))

__________________
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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to auto-populate a date in sequence from page to page, starting with a custom date	JimPerry	Word	2	10-07-2022 01:30 PM
Calculating age of something from a Date Picker	BoringDavid	Word VBA	12	01-13-2014 02:40 AM
Calculating a cell value based on many variables	malawimick	Excel	0	12-14-2011 05:29 PM
calculating points and division in excel	edward masoya	Excel	1	05-09-2011 06:31 AM
Calculating age at date	jamierbooth	Excel	2	02-22-2011 03:35 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:25 PM.