View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TypeType TypeType is offline
external usenet poster
 
Posts: 7
Default If Function Value if true = Date +30days

Hello,

Question about IF function.
A1 = date of order;
B2= either "rejected" or "approved"
C3= +30 days if A2=rejected or +60 days if A2=approved

I tried to creat function for this:

A3 = IF(B2="rejected",A2+30,A2+60)

But the function is not returning a date. For example if

A1= 2/2/1990
B1=rejected
C1 = 32936

I don't know why its not working. Do I need to format it to return a date
somehow?

Thanks!