How do I Subtract 6 months off a date in excel
Hi
Just wanting to subtract 6 months off any date, and present in the format of a date. Cheers |
Answer: How do I Subtract 6 months off a date in excel
How to subtract 6 months off a date in Excel:
That's it! The Code:
EDATE |
How do I Subtract 6 months off a date in excel
Assume you have a date in A1.
=DATE(YEAR(A1),MONTH(A1)-6,DAY(A1)) -- Biff Microsoft Excel MVP "Geoff" wrote in message ... Hi Just wanting to subtract 6 months off any date, and present in the format of a date. Cheers |
How do I Subtract 6 months off a date in excel
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 |
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 |
All times are GMT +1. The time now is 02:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com