Add +4 Months to start date but DAY stays the same

  • Thread starter Thread starter seharvey
  • Start date Start date
S

seharvey

I need to add +4 Months to start date but I would like to have the DA
in end date to stay the same as start date

for example:

Start date A1= 04/05/23
End date B1= 04/09/23

thanks ;
 
Re: Add +4 Months to start date but DAY stays the same
Hi

If you have the analysis toolpack installed you can use
=EDATE(A1,4)


--
Andy.


seharvey > said:
I need to add +4 Months to start date but I would like to have th DAY
in end date to stay the same as start date

for example:

Start date A1= 04/05/23
End date B1= 04/09/23

thanks
Click to expand...




I have installed analysis toolpack and have entered your formula but
don't get what I'm looking for

my date is 04/08/25 YY/MM/DD

when I enter your formula I get 38346 in box B1 as the answer.

I'm looking for 04/12/2
 
I need to add +4 Months to start date but I would like to have the DAY
in end date to stay the same as start date

for example:

Start date A1= 04/05/23
End date B1= 04/09/23

thanks ;)
Click to expand...

=DATE(YEAR(A1),MONTH(A1)+4,DAY(A1))

Of course, if your start date DAY does not exist in your end date month, then
you will get an unexpected result, since you did not define what to do in that
event.


--ron
 
this will do if you don't start with something like 31 may
=DATE(YEAR(E1),MONTH(E1)+4,DAY(E1))
 
Re: Add +4 Months to start date but DAY stays the same
this will do if you don't start with something like 31 may
=DATE(YEAR(E1),MONTH(E1)+4,DAY(E1))

--
Don Guillett
SalesAid Software


Hey Don,

OK, everything works fine but now if I enter any dates where the DAY i
31st and 4 months later there is'nt 31 days in the month it will giv
me the 1st of the next month.

=DATE(YEAR(E444),MONTH(E444)+4,DAY(E444))

these are my results:

A1=04/08/31
B1=04/12/01

I would like to know the formula to go to the last day of the month "I
31 = 30" and for february "IF 31 = 29" or "IF 31 = 28"

thank yo
 
Hi
and to deal also with 31 as day (will return the last day of a amonth)
use
=DATE(YEAR(A1),MONTH(A1)+4,MIN(DAY(A1),DAY(DATE(YEAR(A1),MONTH(A1)+5,0)
)))
 
Back
Top