I want to add 6 months to a certain date in a formula (Excel)
=MIN(DATE(YEAR(A1),MONTH(A1)+{7,6},DAY(A1)*{0,1}))
this caters for 31st March not returning 1st October but 30th September.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Joana" wrote in message
...
I need to calculate 6 months (for example) starting from a certain date
(not
TODAY)...
|