If Function Value if true = Date +30days

[Guest]

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!

 

[T. Valko]

Try formatting the cell as DATE

In Excel dates are really just numbers that are formatted to look like
dates. The numbers are the number of days since a predefined date. That
predefined date is Jan 1 1900. So, the result you got is the 32936th day
since Jan 1 1900, or, when formatted as DATE, 4/3/1990.

Biff

 

[Guest]

Yes, you need to format it as a date.

Format->Cells, then select Date.