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
j1969c Posts 20 Registration date Friday August 28, 2015 Status Member Last seen April 5, 2016 - Sep 11, 2015 at 08:12 PM
Related:
- IF function for "specific date" + 15 calendar days
- Skype last seen days ago - Guide
- Windows calendar show week number - Guide
- Aspire 3 15 keyboard light - Guide
- How to find specific words on a page - Guide
- Click tray calendar - Download - Organisation and teamwork
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
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
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
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Aug 29, 2015 at 10:14 AM
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
"...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
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Sep 11, 2015 at 07:30 PM
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
"...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
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.
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
Sep 11, 2015 at 08:12 PM
It is solved, thank you, have a good weekend!
Aug 28, 2015 at 08:45 PM
Aug 28, 2015 at 08:47 PM
Aug 28, 2015 at 08:49 PM
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!
Aug 29, 2015 at 11:35 AM
Aug 29, 2015 at 06:57 PM