If Then [Solved/Closed]

Report
Posts
1
Registration date
Friday January 13, 2017
Status
Member
Last seen
January 13, 2017
-
Posts
1934
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
July 21, 2021
-
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", ""))

1 reply

Posts
1934
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
July 21, 2021
144
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
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!