IF function for "specific date" + 15 calendar days [Solved/Closed]

- - Latest reply: 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...


See more 

3 replies

Best answer
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
130
1
Thank you
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

Say "Thank you" 1

A few words of thanks would be greatly appreciated. Add comment

CCM 6359 users have said thank you to us this month

j1969c
Posts
20
Registration date
Friday August 28, 2015
Status
Member
Last seen
April 5, 2016
4 -
By the way, my previous reply (in Portuguese) to your kind answer was deleted by some moderator called Ambucias... totally uncalled for...
ac3mark
Posts
13036
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
1463 -
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 > ac3mark
Posts
13036
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
-
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 > ac3mark
Posts
13036
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
-
My fault for not reading (lazy) I apologize!
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
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
130
0
Thank you
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
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
130
0
Thank you
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
ac3mark
Posts
13036
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
1463 -
Isnt this solved? Why do we not discuss this on the thread that you have already responded to?
http://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 -
It is solved, thank you, have a good weekend!