Forum Discussion
JoshuaHughes1
Oct 03, 2024Copper Contributor
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 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))
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
- JoshuaHughes1Copper ContributorIs there a way i can show you the excel sheet? There is no data on there only dates. Thank you for your help
You may place it on OneDrive, Google Drive, whatever, give access to everyone and share the link here.