Updating Dates

JTSalters

New Member
Joined
Nov 16, 2005
Messages
2
I am very new to Excel. I want to put a date in one cell and have it update the date in another cell for 72 days later.
also does anyone have a suggestion on a book for common questions.
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

colbymack

Active Member
Joined
Jul 14, 2005
Messages
333
Put the current date in cell A1. In cell B1 put the formula =A1 +72. That should add 72 days to the date in A1. Make sure it is formatted as a date if it doesn't work the first time.

HTH
 

Watch MrExcel Video

Forum statistics

Threads
1,118,827
Messages
5,574,531
Members
412,601
Latest member
TheBeaniacExpress
Top