If Formula , Adding Days to a Date
 

A B
1 06/06/10

I want to make a formula that calculate as following;

in Cell (B1) if the date in future the result will be [Enrolled], if not it
will be Cell (A1) + 730 Days

If Formula , Adding Days to a Date
 

On Sat, 27 Mar 2010 02:14:01 -0700, Khalid A. Al-Otaibi
wrote:

A B
1 06/06/10

I want to make a formula that calculate as following;

in Cell (B1) if the date in future the result will be [Enrolled], if not it
will be Cell (A1) + 730 Days

Try this formula in cell B1:

=IF(A1TODAY(), "[Enrolled]", A1+730)

Format as date.

Hope this helps / Lars-Åke