If Then
Solved/Closed
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 1980 Registration date Monday August 16, 2010 Status Contributor Last seen December 22, 2022 - Jan 14, 2017 at 05:18 AM
Mazzaropi Posts 1980 Registration date Monday August 16, 2010 Status Contributor Last seen December 22, 2022 - Jan 14, 2017 at 05:18 AM
1 reply
Mazzaropi
Posts
1980
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
December 22, 2022
146
Jan 14, 2017 at 05:18 AM
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
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