Thread: If Formula , Adding Days to a Date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Khalid A. Al-Otaibi Khalid A. Al-Otaibi is offline
external usenet poster
  
Posts: 14
Default 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
Reply With QuoteReply With Quote