| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
Jody, If the current date is in A1 from a key-in, reference from another cell or using NOW(), then in B2 place =A1+45. This will show a calendar date 45 days after the date shown in A1. Should A1 change, B1 will change accordingly. Be sure the cells are formatted the same from the many Date choices in the Format drop-down. I hope I interpreted your problem properly. GeorgeF -- GeorgeF ------------------------------------------------------------------------ GeorgeF's Profile: http://www.excelforum.com/member.php...o&userid=24124 View this thread: http://www.excelforum.com/showthread...hreadid=465963 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
| calculate future date | Excel Worksheet Functions | |||
| calculate anniversary of date after specified date | Excel Worksheet Functions | |||
| calculate no. of years between a date and today's date | Excel Worksheet Functions | |||
| calculate weeks from a start date ( not yr weeks) | Excel Worksheet Functions | |||
Threaded Mode
