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

- Aug 28, 2015 at 02:59 PM - Latest reply:
Posts
20
Registration date
Friday August 28, 2015
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 

11 replies

Best answer
Posts
1834
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
- Aug 28, 2015 at 03:12 PM
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

Thank you, Mazzaropi 1

Something to say? Add comment

CCM has helped 1628 users this month

Posts
20
Registration date
Friday August 28, 2015
Last seen
April 5, 2016
- 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...
Posts
10845
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
November 14, 2018
- 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!
Posts
20
Registration date
Friday August 28, 2015
Last seen
April 5, 2016
>
Posts
10845
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
November 14, 2018
- Aug 29, 2015 at 11:35 AM
Thank you VERY much! I will try it out!
Posts
20
Registration date
Friday August 28, 2015
Last seen
April 5, 2016
>
Posts
10845
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
November 14, 2018
- Aug 29, 2015 at 06:57 PM
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
1834
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
- Aug 29, 2015 at 10:14 AM
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
1834
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
- Sep 11, 2015 at 07:30 PM
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
Posts
10845
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
November 14, 2018
- 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?
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.
Posts
20
Registration date
Friday August 28, 2015
Last seen
April 5, 2016
- Sep 11, 2015 at 08:12 PM
It is solved, thank you, have a good weekend!