If Then [Solved/Closed]

Question

If Then [Solved/Closed]

Report

timmiller109

Posts: 1
Registration date: Friday January 13, 2017
Status: Member
Last seen: January 13, 2017

- Jan 13, 2017 at 03:25 PM
Mazzaropi

Posts: 1916
Registration date: Monday August 16, 2010
Status: Contributor
Last seen: April 16, 2021

- Jan 14, 2017 at 05:18 AM

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

Ask a question

Mazzaropi · Accepted Answer · 2017-01-14T05:18:44-0500

Answer 1 / 1

Mazzaropi

Posts: 1916
Registration date: Monday August 16, 2010
Status: Contributor
Last seen: April 16, 2021

142
Jan 14, 2017 at 05:18 AM

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

If Then [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!