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 to work, however the start date is wrong, it is doing Wednesday to Wednesday instead of Monday to Sunday. Any help appreciated.

=COUNTIFS(‘Annuity Tracker’!G:G,”<=” & B1,’Annuity Tracker’!G:G,”>=”& B1-(WEEKDAY(B2)-2))

​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 to work, however the start date is wrong, it is doing Wednesday to Wednesday instead of Monday to Sunday. Any help appreciated.   =COUNTIFS(‘Annuity Tracker’!G:G,”<=” & B1,’Annuity Tracker’!G:G,”>=”& B1-(WEEKDAY(B2)-2))  Read More

​