IF function for "specific date" + 15 calendar days
Solved/Closed
josecruz
-
28 Aug 2015 à 14:59
j1969c Posts 20 Registration date Friday 28 August 2015 Status Member Last seen 5 April 2016 - 11 Sep 2015 à 20:12
j1969c Posts 20 Registration date Friday 28 August 2015 Status Member Last seen 5 April 2016 - 11 Sep 2015 à 20:12
Related:
- IF function for "specific date" + 15 calendar days
- Skype last seen days ago - Guide
- How to search for a specific word on a webpage - Guide
- Excel add days to date - Guide
- How do i find a specific video on youtube - Guide
- How to refresh calendar on mac - Guide
3 responses
Mazzaropi
Posts
1985
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
28 Aug 2015 à 15:12
28 Aug 2015 à 15:12
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 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
29 Aug 2015 à 10:14
29 Aug 2015 à 10:14
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 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
11 Sep 2015 à 19:30
11 Sep 2015 à 19:30
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 28 August 2015
Status
Member
Last seen
5 April 2016
4
11 Sep 2015 à 20:12
11 Sep 2015 à 20:12
It is solved, thank you, have a good weekend!
28 Aug 2015 à 20:45
28 Aug 2015 à 20:47
28 Aug 2015 à 20:49
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!
29 Aug 2015 à 11:35
29 Aug 2015 à 18:57