Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
How do I add dates in Excel - Cell 1 Cell 2 10/03/04 I want to put 6 months from Cell 1 date. I know i can add the days, but can I make it too return 10/09/04? Thanks |
#2
![]() |
|||
|
|||
![]()
Hi
=MIN(DATE(YEAR(A1),MONTH(A1)+6,DAY(A1)),DATE(YEAR( A1),MONTH(A1)+7,0) returns the date 6 months from date in cell A1, or when there is less days in future month then day number in A1, then the last day in month 6 months of date in A1. When you have Analysis Toolpack Add-in installed, then you can use =EDATE(A1,6) which does exactly same as first formula. -- When sending mail, use address arvil<attarkon.ee Arvi Laanemets "Natalie" wrote in message ... Hi, How do I add dates in Excel - Cell 1 Cell 2 10/03/04 I want to put 6 months from Cell 1 date. I know i can add the days, but can I make it too return 10/09/04? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I get Excell to sort dates that range from 1800 to 1900's | New Users to Excel | |||
How sort dates just by day/month and NOT year if all 3 given in ce | Excel Worksheet Functions | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
due dates | New Users to Excel | |||
I get wrong dates when i paste from a different sheet into a new s | Excel Discussion (Misc queries) |