Add 6 months to an Excel date
Solved
MichaelM
Posted messages
47
Registration date
Status
Member
Last intervention
-
Dan3000 Posted messages 15 Registration date Status Member Last intervention -
Dan3000 Posted messages 15 Registration date Status Member Last intervention -
Hello,
I am looking for a formula that would allow me to add 6 months to a date.
What I would like is that if I enter 01/01/2010 in A1, the cell B1 with the famous formula gives me 01/07/2010.
The whole thing without considering the exact value of the 6 months.
Because I tried = A1+180 but with months having less than 30 days it doesn't match.
I just want to have the same date with 6 units more in the month part.
It's a bit complicated to explain.....BUT THANK YOU !!!!!
Configuration: Windows 7 / Internet Explorer 8.0
I am looking for a formula that would allow me to add 6 months to a date.
What I would like is that if I enter 01/01/2010 in A1, the cell B1 with the famous formula gives me 01/07/2010.
The whole thing without considering the exact value of the 6 months.
Because I tried = A1+180 but with months having less than 30 days it doesn't match.
I just want to have the same date with 6 units more in the month part.
It's a bit complicated to explain.....BUT THANK YOU !!!!!
Configuration: Windows 7 / Internet Explorer 8.0