Home

FORMULA TO TOTAL NUMBER OF DATES VERSUS JUST RAW NUMBERS

Highlighted
ExcelBossJock930
Occasional Visitor

Attached is a sample spreadsheet to keep track of the activity incurred by participants in a club.

 

In Cells C8 and D8, I want to see a TOTAL for the number of dates they were active.  Can I install a formula to count that for me, versus my manually inserting 4 or 5 (in this example)?

 

Thanks....

 

NORM

1 Reply
Highlighted

Hello. Use the COUNT() function.

 

Related Conversations
Date filtering of Bing Searches
PhilipE3 in Discussions on
2 Replies
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies
Setting Date in Stored Procedure
Tim Hunter in SQL Server on
1 Replies
Leap year formula
Hattsoff in Excel on
4 Replies