| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add 45 days to a date....
"ARR" wrote in message ... I am brand new to Excel, have only inputted information and corrected issues if a formula goes off... I've never had to start from scratch until today. I need something that should be very simple, but I haven't been able to figure it out. I am trying to have a date automatically imputted into a cell that is 45 days later than a manually entered date in a previous cell... example. I would enter 1/01/10 in E3 and I would want the date 2/15/10 to show up in F3.. 2/15/10 being 45 days after 1/1/10. So, any time I entered a date into the E column, a date 45 days later would show up in the F column. I hope that makes sense and any help would be appreciated as I have no idea what I am doing... it's Excel 2003. In F3, do =E3+45, and format as date. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to pull <=14 Days, <=30 Days, 30 Days from a date column | Excel Discussion (Misc queries) | |||
| Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
![George[_12_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
