Multiple dates

[Will2me]

I want to stop counting dates based on other cells.

cell B25 = date we received a document from customer
Cell B27 = First reminder sent customer to send us the document
Cell B28 = second reminder sent

I want the formula to count how many days from the date in cell B27 and stop counting when a date is put in cell B28. However if Cell 28 is empty I want the cell that the formula is in to stay clear. Likewise if we don’t have to send the second reminder then the formula to count the days from B27 to B25

i have tried using multiple IF statements but because I have it saying if Cell B25 is empty count B27-28 days but if B28 is empty to 27-25 it gets confused and I get an error message.

is this possible or is it too elaborate?

 

[Sufiyan97]

Modified

Book3
	B	C	D
25	date we received a document from customer	2/20/2021
26
27	First reminder sent customer to send us the document	2/23/2021
28	second reminder sent	2/25/2021	2
Sheet1

Cell Formulas
Range	Formula
D28	D28	=IF(ISBLANK(C28),"",IF(ISBLANK(C28),IF(ISBLANK(C25),"",C27-C25),C28-C27))

 

[Will2me]

Is it what you want

Book3
	B	C	D
25	date we received a document from customer	2/20/2021
26
27	First reminder sent customer to send us the document	2/22/2021
28	second reminder sent	2/24/2021
Sheet1

Cell Formulas
Range	Formula
D28	D28	=IF(ISBLANK(C28),TODAY()-C27,"")

Thank you, it’s close but not quite there
I need it to still show how many days it was in that stage of sending the first reminder and sending the second.
I can do this by changing “” in the formula you provided to Days(B28,B27)
Also when you put a date in of actually receiving the document the count needs to stop and stay there as well

 

[Sufiyan97]

Thank you, it’s close but not quite there
I need it to still show how many days it was in that stage of sending the first reminder and sending the second.
I can do this by changing “” in the formula you provided to Days(B28,B27)
Also when you put a date in of actually receiving the document the count needs to stop and stay there as well

I have modified it again have you tried again?

 

[Will2me]

I have modified it again have you tried again?

I have, sadly doesn’t work

 

[Will2me]

I have been trying the following if this helps you understand my aim a bit better:
=IF(ISBLANK(B28),””,DAYS(B28,B27)), IF(ISBLANK(B25), DAYS(TODAY(),B28),DAYS(B25,B28)

 

[Sufiyan97]

Try if any of them works

Book3
	A	B	C
25	date we received a document from customer	2/10/2021
26
27	First reminder sent customer to send us the document	2/13/2021
28	second reminder sent	2/15/2021	2
29			5
30			2
Sheet1

Cell Formulas
Range	Formula
C28	C28	=IF(ISBLANK(B28),IF(ISBLANK(B25),"",B27-B25),B28-B27)
C29	C29	=IF(ISBLANK(B28),"",IF(ISBLANK(B25),TODAY()-B28,B28-B25))
C30	C30	=IF(ISBLANK(B28),B27-B25,B28-B27)

 

[Will2me]

Try if any of them works

Book3
	A	B	C
25	date we received a document from customer	2/10/2021
26
27	First reminder sent customer to send us the document	2/13/2021
28	second reminder sent	2/15/2021	2
29			5
30			2
Sheet1

Cell Formulas
Range	Formula
C28	C28	=IF(ISBLANK(B28),IF(ISBLANK(B25),"",B27-B25),B28-B27)
C29	C29	=IF(ISBLANK(B28),"",IF(ISBLANK(B25),TODAY()-B28,B28-B25))
C30	C30	=IF(ISBLANK(B28),B27-B25,B28-B27)

The formula you used for C29 is the closest however within that formula I need the count to stop if a second reminder is sent. So I need to the counter for the first reminder to stop so we know how many days since we sent that first reminder it has been sat with the customer and then once the second reminder is sent we need to know how many days it has been with the customers since then.
Almost like:
=IF(ISBLANK(B27),"",IF(ISBLANK(B25),TODAY()-B27,B25-B27),IF(ISBLANK(B28),"",B28-B27))
but it says there are too many arguments in this one formula if I use that

 

[Sufiyan97]

The formula you used for C29 is the closest however within that formula I need the count to stop if a second reminder is sent. So I need to the counter for the first reminder to stop so we know how many days since we sent that first reminder it has been sat with the customer and then once the second reminder is sent we need to know how many days it has been with the customers since then.
Almost like:
=IF(ISBLANK(B27),"",IF(ISBLANK(B25),TODAY()-B27,B25-B27),IF(ISBLANK(B28),"",B28-B27))
but it says there are too many arguments in this one formula if I use that

Please confirm

if we received document from customer then DON'T need to send reminder right?

if first reminder is sent then we need to count TODAY - DATE OF FIRST REMINDER right?

if second reminder is sent then we need to count DATE OF SECOND REMINDER - DATE OF FIRST REMINDER right?

or any other condition?

 

[Will2me]

Please confirm

if we received document from customer then DON'T need to send reminder right?

if first reminder is sent then we need to count TODAY - DATE OF FIRST REMINDER right?

if second reminder is sent then we need to count DATE OF SECOND REMINDER - DATE OF FIRST REMINDER right?

or any other condition?

I have managed to figure it out but requires the formula to be split up into two parts and two cells:

For Cell B27 (the following formula is located in cell H27) =IF(ISBLANK(B27),"",IF(ISBLANK(B25),TODAY()-B27,B25-B27)) and then =IF(ISBLANK(B28),H27,DAYS(B28,B27))

This is meant to tell it that when B27 is blank do nothing, if B25 is blank do B27 - today, if neither are blank then do b27-b25 --> then if B28 is blank just show H27 otherwise only count B27-B28

i have then modified them for the next two reminders as well