adding days to a date field

blondtp · Apr 10th, 2002, 04:00 PM

In cell D3 we have date 02/04/02 in cell d4 i want it to add 14 days automatically ie the answer to be 02/16/02. I have looked eomonth and several others but they are all calling for and end date, I don't have that I want to create it. Please help

Mark W. · Apr 10th, 2002, 04:00 PM

=D3+14

Of course, the result would be 2/18/02.

[ This Message was edited by: Mark W. on 2002-04-10 15:02 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 10th, 2002, 04:00 PM	#1
blondtp New Member Join Date: Apr 2002 Location: Houston Posts: 1	In cell D3 we have date 02/04/02 in cell d4 i want it to add 14 days automatically ie the answer to be 02/16/02. I have looked eomonth and several others but they are all calling for and end date, I don't have that I want to create it. Please help

Apr 10th, 2002, 04:00 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	=D3+14 Of course, the result would be 2/18/02. [ This Message was edited by: Mark W. on 2002-04-10 15:02 ]