Count total days between opened date and today ()

[mayoung]

A B C
[TABLE="width: 500"]
<tbody>[TR]
[TD]OPENED DATE[/TD]
[TD]CLOSED DATE[/TD]
[TD]TOTAL DAYS[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

LOOKING FOR FORMULA TO COUNT TOTAL DAYS (C2) (INCLUDING WEEKENDS AND HOLIDAYS), BETWEEN TODAY () MINUS OPENED DATE (A2) AND STOP COUNT (FREEZE) ONCE CLOSED DATE IS ENTERED (B2).

 

[jtakw]

Hi,

Is this what you mean?

Book1
	A	B	C	D
1	Opened Date	Closed Date	Total Days	Open/Today insclusive
2	8/1/2018		13	14
3	8/1/2018	8/13/2018	12	13
Sheet185

Cell Formulas
Range	Formula
C2	=IF(B2="",TODAY()-A2,B2-A2)
D2	=IF(B2="",TODAY()-A2+1,B2-A2+1)

 

[JoeMo]

Not sure what you mean by STOP COUNT. Does this do what you want?

IF(B2="",TODAY()-A2,B2-A2)

 

[mayoung]

Hi,

Is this what you mean?

	A	B	C	D
Opened Date	Closed Date	Total Days	Open/Today insclusive

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]8/1/2018[/TD]
[TD="align: right"][/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]14[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]8/1/2018[/TD]
[TD="align: right"]8/13/2018[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]13[/TD]

</tbody>

Sheet185​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C2[/TH]
[TD="align: left"]=IF(B2="",TODAY()-A2,B2-A2)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D2[/TH]
[TD="align: left"]=IF(B2="",TODAY()-A2+1,B2-A2+1)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Thank You worked great!

 

[mayoung]

Thank You Worked Great!

 

[jtakw]

You're welcome.

 

[mayoung]

if you remove the open date in cell A2 cell C2 will show 43339 and cell D2 SHOWS 43340. Is there away to make it show zero?

 

[jtakw]

if you remove the open date in cell A2 cell C2 will show 43339 and cell D2 SHOWS 43340. Is there away to make it show zero?

Here you go:

Book1
	A	B	C	D
1	Opened Date	Closed Date	Total Days	Open/Today insclusive
2	8/1/2018		26	27
3			0	0
4	8/1/2018	8/13/2018	12	13
Sheet212

Cell Formulas
Range	Formula
C2	=IF(A2="",0,IF(B2="",TODAY()-A2,B2-A2))
D2	=IF(A2="",0,IF(B2="",TODAY()-A2+1,B2-A2+1))