Microsoft Office Forums - View Single Post - [Solved] Count the Number of Cells Containling Dates

Thread: [Solved] Count the Number of Cells Containling Dates

View Single Post

Old

05-19-2019, 10:46 AM

xor

xor is offline

xor uses Windows 10

Windows 10 xor uses Office 2016

xor uses Office 2016

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

In cell B1:

=(A1>=$C$1)*(A1<=$D$1)*(CELL("format";A1)="D1")

copied down to B10 and then =SUM(B1:B10)

where C1 is the earliest allowed date and D1 the latest allowed date.
Please note that the last "D1" is not a cell reference but a format code.

Reply With Quote