Count the Number of Cells Containling Dates

		Microsoft Office Forums > Microsoft Excel > Excel
Count the Number of Cells Containling Dates

FAQ

Mark Forums Read

Thread Tools

Display Modes

05-19-2019, 02:23 PM

skeezix

Windows 10 Count the Number of Cells Containling Dates

Office 97-2003

Competent Performer

Join Date: Jan 2019

Posts: 115

Quote:

Originally Posted by xor

In cell B1:

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

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

Thank you for your help. Unfortunately I don't understand much about formulas in Excel, and so I don't think that I can use yours. Please see the image below. The formula would go in one of the blank cells at the bottom of each column.

Attached Images

Excel example.jpg (139.7 KB, 41 views)

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
count the number of text in a cell based off a different cells text	Kubi	Excel	4	08-24-2017 05:53 PM
count a number of cells based on the beginning of a order number	Kubi	Excel	2	08-06-2017 08:54 PM
Distribute text in one cell across a range of cells (overcoming selection.range.cells.count bug)	slaycock	Word VBA	0	02-18-2017 07:00 AM
How to Count from Different Cells?	Shahzad	Excel	3	06-26-2010 01:06 AM
Count range cells eliminating merge cells	danbenedek	Excel	0	06-15-2010 12:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:32 PM.