josecruz, Good morning.
"
...what I am looking for is for an IF function that alerts me after 15 days have occurred after a specific date, where the date is A1 and the cell for alerting is Z1..."
The formula that I gave you in the previous message is
exactly what you want.
It is not yet clear what's the layout of your spreadsheet.
Explanation:
A1 =
15/08/2015
Z1 --> Formula
=IF (TODAY() >= A1+15, "PAY NOW", "HOLD")
Obs.:
TODAY Function is a dynamic function at excel.
It returns always a date of the day the file is opened.
a) If you open your file
TODAY (29-AUG-2015)
Today() =
29/08/2015
A1 =
15/08/2015
A1+15 =
30/08/2015
....formula composition....
IF (29/08/2015 >= 30/08/2015 , "PAY NOW", "HOLD")
as 29/08/2015 >= 30/08/2015 is
FALSE
then appears
HOLD at
Z1
b) If you open your file
TOMORROW (30-AUG-2015)
Today() =
30/08/2015
A1 =
15/08/2015
A1+15 =
30/08/2015
....formula composition....
IF (30/08/2015 >= 30/08/2015 , "PAY NOW", "HOLD")
as 30/08/2015 >= 30/08/2015 is
TRUE
then appears
PAY NOW at
Z1
I hope this little explanation can kill the doubts.
--
Belo Horizonte,
Brasil.
Marcílio Lobão
By the way, the posted formulas has TODAY() ( a dynamic variable of date, not an integer), and your formula does not, that is where the failure is occurring!
=IF(TODAY()>=B9+15,"PAY NOW","HOLD",IF(u9="PAID","PAID"))
Many thanks, Jose Cruz