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
|