| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Adding 6 months to any given date
is it possible to add 6 months to a given date?
i.e. if in cell A1 the date is 04/05/03, then cell B1 should return the date plus 6 months ie 04/12/03. the only way ive been able to get something near is by adding 182.5 which is half a year in days but this obviously doesnt account for the different months having varying amounts of days. Any Ideas? Regards Hoyt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding # of days to a date | Excel Worksheet Functions | |||
| X-Y Graph with Months, Not Date on Axis | Excel Discussion (Misc queries) | |||
| Adding dates to get a date | Excel Worksheet Functions | |||
| Getting a date six months back | Excel Worksheet Functions | |||
| Adding a date and time | Excel Worksheet Functions | |||
Threaded Mode
