| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculate a particular date
Add 90 to the cell that has the date.
If Cell A1 has the date of 10/15/1979 the following formula in cell B1 will produce the date of 1/13/1980 =A1+90 Hope this helps... -- Kevin Backmann "Felicity" wrote: I have a row of different date when people joined a study. I need to calculate the exact date three months afterwards. How do I create a formular, so I don't have to calculate it separately for each different person(given that thye joined on different dates? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tricky Date calculation: How to calculate a future date | Excel Discussion (Misc queries) | |||
| Auto calculate for date + days forward to yield new date | Excel Worksheet Functions | |||
| formula to calculate age using birth date and current date | Excel Worksheet Functions | |||
| formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
| Calculate month-end date from date in adjacent cell? | Excel Worksheet Functions | |||
Threaded Mode
