View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Lars-Åke Aspelin[_4_] Lars-Åke Aspelin[_4_] is offline
external usenet poster
 
Posts: 83
Default 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