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...


3 replies

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
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
1
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?
0
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...
0
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!
0
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!
0
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!
0
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
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.
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
0
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
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
0
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.
0
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!
0