Date formula

[Alpacino]

Hi again,
What is the formula to find out 60 days from today??
Thanks in advance
Alan

 

[repairman615]

Hello,

<TABLE style="WIDTH: 116pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=154><COLGROUP><COL style="WIDTH: 116pt; mso-width-source: userset; mso-width-alt: 2464" width=154><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #eaf1dd; WIDTH: 116pt; HEIGHT: 15.75pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=21 width=154>=TODAY()+60</TD></TR></TBODY></TABLE>

 

[GK039]

Try:
=DATE(YEAR(TODAY()),MONTH(TODAY())+2,DAY(TODAY()))

Hi again,
What is the formula to find out 60 days from today??
Thanks in advance
Alan

 

[DeCaelo]

Proving your date is in A1, I believe it's as simple as =A1+60.

 

[Alpacino]

Thanks
I got a formula here to work out what quarter today's date is in on calendar year however my company year starts in march how do u change the year start date

=ROUNDUP(MONTH(A1)/3,0)

 

[Peter_SSs]

Is this what you mean?

=ROUNDUP(MONTH(EDATE(A1,-2))/3,0)