Counting how many dates in a range fall into this week and last week

Does your week number start on a Sunday or a Monday? i.e. would 6th Jan be counted in this week or last week?

Pete

Hi Pete - my week starts on a Sunday

regards
Aneel

Okay, this will give you the count for the current week:

Formula:

=COUNTIFS(A:A,">="&TODAY()-WEEKDAY(TODAY(),2),A:A,"<"&TODAY()-WEEKDAY(TODAY(),2)+7)

assuming your dates are in column A, and this will give you the count for the previous week:

Formula:

=COUNTIFS(A:A,">="&TODAY()-WEEKDAY(TODAY(),2)-7,A:A,"<"&TODAY()-WEEKDAY(TODAY(),2))

Hope this helps.

Pete

Spot on thanks Pete

i've been at this most of this morning and it all looks so simple now I see the solution :-)

Glad to be of help. Please mark the thread as Solved if you consider it to be so. Also, you can show your appreciation to a poster by clicking on the "star" icon in the bottom left corner of any post that you have found to be helpful (not only in this thread).

Pete