Report

If Then [Solved]

Ask a question timmiller109 1Posts Friday January 13, 2017Registration date January 13, 2017 Last seen - Last answered on Jan 14, 2017 at 05:18 AM by Mazzaropi
Im trying to write a formula that returns a yes or no.

I have to check if product is or isnt in warranty and need to know if a date is greater than or less than a year old. If it greater than a year, no, if it is less than a year, yes. As of right now, my formula looks like this but it doesnt seem to work. thanks in advance.

=IF($H$5-TODAY()>365,"Yes",IF($H$5-TODAY()<365, "No", ""))
Helpful
+1
plus moins
timmiller109, Good morning.

Suppose:

A1 --> DATE OF PURCHASE

B1 --> FORMULA --> =IF(TODAY()-A1<=365, "-- Yes --", "No")

Is that what you want.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Was this answer helpful?  
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!