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

josecruz - Aug 28, 2015 at 02:59 PM - Latest reply: j1969c 20 Posts Friday August 28, 2015Registration date April 5, 2016 Last seen
- 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
Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - 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 1705 users this month

j1969c 20 Posts Friday August 28, 2015Registration date April 5, 2016 Last seen - 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...
ac3mark 9909 Posts Monday June 3, 2013Registration dateModeratorStatus July 14, 2018 Last seen - 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 20 Posts Friday August 28, 2015Registration date April 5, 2016 Last seen > ac3mark 9909 Posts Monday June 3, 2013Registration dateModeratorStatus July 14, 2018 Last seen - Aug 29, 2015 at 11:35 AM
Thank you VERY much! I will try it out!
j1969c 20 Posts Friday August 28, 2015Registration date April 5, 2016 Last seen > ac3mark 9909 Posts Monday June 3, 2013Registration dateModeratorStatus July 14, 2018 Last seen - 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
Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - 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
Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - 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
ac3mark 9909 Posts Monday June 3, 2013Registration dateModeratorStatus July 14, 2018 Last seen - 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.
j1969c 20 Posts Friday August 28, 2015Registration date April 5, 2016 Last seen - Sep 11, 2015 at 08:12 PM
It is solved, thank you, have a good weekend!