tigger6333
New Member
- Joined
- Sep 6, 2009
- Messages
- 43
I have a worksheet that contains dates across row 1 starting in Column B. Each day a new column is added. I want to count the number of cells containing dates.
If I use COUNTA(B1:F1) on one day the next day it should be COUNTA(B1:G1)
How can I allow for a dynamically changing column limit?
Cheers
tigger
If I use COUNTA(B1:F1) on one day the next day it should be COUNTA(B1:G1)
How can I allow for a dynamically changing column limit?
Cheers
tigger