If Then [Solved/Closed]

Report
Posts
1
Registration date
Friday January 13, 2017
Status
Member
Last seen
January 13, 2017
-
Posts
1916
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 16, 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
1916
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 16, 2021
142
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!