IF and IFERROR in same formula?

[thanan]

I am trying to use IFERROR and IF functions within the same formula but I am unsure why I do not get the results I need.
Cell B4 contains a date, so I am unsure if that may be the issue.

=IFERROR(IF('Sheet2'!B4>0,'Sheet2'!B4+30),"REPAIR")

Whenever I write that formula and I have a date in there the value returned is 44594 instead of the date + 30.

Please advise. Thank you so much for your help.

 

[Candyman8019]

Looks like the format of your cell may be number rather than date.

 

[Joe4]

Welcome to the Board!

It is important to understand how Excel stores dates.
Excel stores dates as numbers, specifically the number of days since 1/0/1900 (you can easily see this by changing the format on a date cell to "General").
So all that dates are in Excel is numbers with special formatting.

If you see a value like 44594, then the cell is probably formatted as General, and you just need to change it to use a Date format.

 

[thanan]

I forgot that simple yet important detail! Thank you so much.

 

[Joe4]

You are welcome.
Glad I was able to help!