I need to create a formula IF with dates and 2 variables

adrianmty - Jul 14, 2017 at 08:18 PM - Latest reply: Mazzaropi 1826 Posts Monday August 16, 2010Registration dateContributorStatus April 15, 2018 Last seen
- Jul 15, 2017 at 08:53 AM
Im trying to create the following formula in excel
If theres number greater than 0 in a column and if the date in the other column is before one month from today date result = SELL
See more 

1 reply

Reply to this topic
Mazzaropi 1826 Posts Monday August 16, 2010Registration dateContributorStatus April 15, 2018 Last seen - Jul 15, 2017 at 08:53 AM
0
Helpful
adrianmty, Good morning.

Suppose:
A2 --> Cell with number
B2 --> DATE
C2 --> Result --> Formula

Try to use it:
C2 --> =IF(AND(A2>0,B2<=TODAY()-30), "SELL", "")

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Respond to Mazzaropi