| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
plus 6 months
Try this:
=EDATE(A1,6) Format as Date. EDATE requires the Analysis ToolPak add-in be installed. If you enter the formula and get a #NAME? error see help on the EDATE function and it'll tell how to fix the problem. -- Biff Microsoft Excel MVP "lesiofamily" wrote in message ... is there a function which would calculate new date from a given date? e.g. column A row 1= 07.03.2009 I would like column B row 1 to show= 01.03.2010 - which is in 6 months is it possible? any suggestions welcome thank you -- lb |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating months with half months. | Excel Discussion (Misc queries) | |||
| 3 months prior and 3 months post a date | Excel Worksheet Functions | |||
| Adding months to dates should account for 28-30-31 day months | Excel Worksheet Functions | |||
| converting months to years and months??? | Excel Discussion (Misc queries) | |||
| How do i change 15 months to read 1 year and 3 months? | Excel Discussion (Misc queries) | |||
Threaded Mode
