Forum Discussion
COUNTIFS Week/Month start error
Hello, I've tried to add a formula which can automatically read data from a spreadsheet and tell me how many appointments i have week to date and month to date once i change the date. It seems...
Not sure what is what in your formula.
Monday of the week on date in B2
=B2-WEEKDAY(B2,3)For the Sunday add 6