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!