Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

If Then [Solved/Closed]

Report
Posts
1
Registration date
Friday January 13, 2017
Status
Member
Last seen
January 13, 2017
 -
Posts
1829
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
 -
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", ""))
See more

1 reply

Answer 1 / 1
Posts
1829
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
 135
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
Thank you
1
Thank you

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

CCM 3391 users have said thank you to us this month

Ask a question