adding months to a date value

  • Thread starter Thread starter rsridharan
  • Start date Start date
R

rsridharan

Hi everybody,

advance thanx to all.


my requirement is to add a months to a date value.

for example if the date is '06-06-1976' (dd-mm-yyyy) format and if
want to add 24 months to the above date then the value become
'06-06-1978'.

in the same way if i give any value in place of months the date valu
should change accordingly.

please help to me .

Sridhara
 
What if the date is 02/29/2000, would you want 03/01/2002?
If so use

=DATE(YEAR(A1),MONTH(A1)+24,DAY(A1))
 
Hi

If it is an Excel date and you have the Analysis Toolpack add-in installed,
you can use:
=EDATE(A1,24)
to add 24 months etc.
 
From a posting by Frank Kabel
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))))
 
A1 Date B1 Months C1 New Date
A2 6-Jun-1976 B2 15 C2 9/6/1977

Place this formula is C2

=DATE(YEAR(A2),MONTH(A2)+B2,DAY(A2))
 
Back
Top