How to count date cells for monday of this week [Solved/Closed]
doublewitt14
Posts Sunday April 27, 2014Registration date
September 29, 2014
Last seen
-
Sep 25, 2014 at 07:53 AM - Latest reply: doublewitt14
Posts Sunday April 27, 2014Registration date
September 29, 2014
Last seen
- Sep 29, 2014 at 11:49 AM
I would like to count the number of cells with date = to MONDAY of this current week and also MONDAY of the following week within a defined range. Would appreciate your guidance...
thanks for the effort but that's not quite what I need - perhaps I need to explain better. Can we create a formula based on the year's current week number in another cell? In other words, count total number of cells containing monday's date within current week 39.
So you want to count the number of times 22-9-2014 occurs in a range?:
=COUNTIF(A1:A30,"=22-9-2014")
or you can use an additional column to check if the date matches your criteria with this formula:
=IF(AND(WEEKNUM(A1)=39,WEEKDAY(A1)=2),1,0)
If the date is a Monday in week 39 then the cell shows a 1, you can then add all the 1's to get a total.
