| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
=JoingingDAte + 56
where startdate would be a reference to the cell with the start date. ex: if joining date is in D3 =D3+56 Format the cell with the Formula as date. "Kelly Lim" wrote in message ... Dear users... I have a spreadsheet...having two columns of "Joining Date" and " Due Date".... Let's say when i key in the joining date is 04/07/05....Can someone please teach me of what formula should i use to make it automatically add in 56 days and show out on the "Due Date" column into 29/08/05 rather than me having to manually count to add in 56 days and key in the date... Please help me asap with this...Thanks a lot to everyone out there.... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Cell formats to date fields automatically | Excel Worksheet Functions | |||
| Automatically Insert DATE, so that DATE will NOT change | Excel Worksheet Functions | |||
| Automatically enter date and time but only update once. | New Users to Excel | |||
| how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
| How to change (delivery) days and automatically the receive date in an other cell? | Excel Worksheet Functions | |||
Threaded Mode
