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, 11:04 PM

ArviLaanemets ArviLaanemets is offline

Calculate date due from variable date to semi-fixed date

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 949

Quote:

Originally Posted by wsnow

Okay, you HAVE to explain to me why that worked!!!!

It's better to explain why your formula didn't work!
MONTH(3) returns the month of date 1/3/1900 (i.e. 1, as it will be January);
DAY(31) returns the day of date 1/31/1900.

The syntax of DATE() function is:
DATE(YearNumber, MonthNumber, DayNumber)

« 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.