# IF function for "specific date" + 15 calendar days

Solved/Closed
josecruz - Aug 28, 2015 at 02:59 PM
j1969c Posts 20 Registration date Friday August 28, 2015 Status Member Last seen April 5, 2016 - Sep 11, 2015 at 08:12 PM
Hello, maybe you can help with the following...

I am looking for an IF function that alerts me to "PAY NOW" or to "HOLD" as follows; PRODUCT ENTRY DATE - IF TODAY is = > than ENTRY DATE + 15 days "PAY NOW" - IF TODAY is BETWEEN ENTRY DATE AND up to 14 days later "HOLD"

Any help will be MUCH appreciated...

Related:

## 3 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Aug 28, 2015 at 03:12 PM
Jose cruz, Good afternoon.

Try to use:

=IF(TODAY() => PRODUCT ENTRY DATE + 15;"PAY NOW";"HOLD")

Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
j1969c Posts 20 Registration date Friday August 28, 2015 Status Member Last seen April 5, 2016 4
Aug 28, 2015 at 08:45 PM
Hello Marcilio, thanks... 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. For example I am trying this formula, but it does not work... [cell Z1] =IF(Z1=>A1+15,"PAY NOW",IF(Z1=<A1+14,"HOLD"))... where am I going wrong?
j1969c Posts 20 Registration date Friday August 28, 2015 Status Member Last seen April 5, 2016 4
Aug 28, 2015 at 08:47 PM
By the way, my previous reply (in Portuguese) to your kind answer was deleted by some moderator called Ambucias... totally uncalled for...
Blocked Profile
Aug 28, 2015 at 08:49 PM
Well actually, the CHARTER (top right hand link of this page that is marked CHARTER), says all posts are to be in English. If you wish to post in other languages, then make certain you log into those servers that post in that language! Thank you for your understanding!

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!
j1969c Posts 20 Registration date Friday August 28, 2015 Status Member Last seen April 5, 2016 4 > Blocked Profile
Aug 29, 2015 at 11:35 AM
Thank you VERY much! I will try it out!
j1969c Posts 20 Registration date Friday August 28, 2015 Status Member Last seen April 5, 2016 4 > Blocked Profile
Aug 29, 2015 at 06:57 PM
My fault for not reading (lazy) I apologize!
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Aug 29, 2015 at 10:14 AM
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.

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
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Sep 11, 2015 at 07:30 PM
Jose Cruz, Good evening.

"...Mr. Mazzaropi: Why is excell telling me that this formula has too many arguments?
=IF(TODAY()>=B9+15,"PAY NOW","HOLD",IF(u9="PAID","PAID"))
Many thanks, Jose Cruz...
"

What's your intention with this formula?

--
Belo Horizonte, Brasil.
Marcílio Lobão
Blocked Profile
Sep 11, 2015 at 07:38 PM
Isnt this solved? Why do we not discuss this on the thread that you have already responded to?
https://ccm.net/forum/affich-839488-function-has-too-many-arguments

Please forgive me if I have over stepped my boundaries, but I got caught in a loop for second!

Should I Just delete this and move it all over to the other thread? I would hate to lose a solved answer just because it is a duplicate.
j1969c Posts 20 Registration date Friday August 28, 2015 Status Member Last seen April 5, 2016 4
Sep 11, 2015 at 08:12 PM
It is solved, thank you, have a good weekend!