Formatting

[Raistlin]

How do I get excel to give my a date 3 months from any date I type in.

I tried =SUM(C3)+90 but it gives me a date XX.XX.1900 when I drag the
formula down the spreadsheet

 

[Peo Sjoblom]

=DATE(YEAR(C3),MONTH(C3)+3,DAY(C3))

--


Regards,


Peo Sjoblom

 

[ShaneDevenshire]

Hi,

First, if there are Excel legal dates in C3 then the formula =C3+90 should
return a date 90 days into the future. I'm not clear what you are actually
getting but dates don't have periods in them which suggests something else is
in C3 other than a real date, which means any formula we give you will fail.

Second, you could try changing the format of the cell with the formula to a
date format.

Third, you can get a date 3 months from any date using
=EDATE(C3,3)
that will give the date 3 months into the future from the date in C3. The
EDATE function is part of the Analysis ToolPak so you must attach it by
choosing Tools, Add-in, and putting a check beside it.

If this helps, please click the Yes button