| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I Subtract 6 months off a date in excel
If you have the analysis toolpack installed
=EDATE(yourdate,-6) -- John C "JE McGimpsey" wrote: One way: A1: <date A2: =DATE(YEAR(A1),MONTH(A1)-6,DAY(A1)) Note that A1= 12/31/2008 will return 07/01/2008 in A2 since June has onl 30 days (US formatting). In article , Geoff wrote: Hi Just wanting to subtract 6 months off any date, and present in the format of a date. Cheers |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I subtract/add a known number of days/months from a date? | Excel Worksheet Functions | |||
| subtract years and months (as in ages) from another age | Excel Discussion (Misc queries) | |||
| Subtract 6 months | Excel Worksheet Functions | |||
| HOW TO SUBTRACT A YEAR+MONTH AND SHOW DIF IN MONTHS? | Excel Worksheet Functions | |||
| Subtract MM/DD/YYYY and get # months | Excel Discussion (Misc queries) | |||
![John C[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
