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...
Is 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.
- https://docs.google.com/spreadsheets/d/1x_LYOXuB6k9VOSa-ZZGDK_q1jWlxPsAW/edit?usp=drivesdk&ouid=117707044031102458887&rtpof=true&sd=true
I'm hoping i've done this correctly? Thanks againIn 'AGS Stats'!C30:
=COUNTIFS('Annuity Tracker'!G:G,"<=" & B1,'Annuity Tracker'!G:G,">=" & B1-WEEKDAY(B2, 3))
And in 'AGS Stats'!D30:
=COUNTIFS('Annuity Tracker'!J:J,"<=" & B1,'Annuity Tracker'!J:J,">=" & B1-WEEKDAY(B2, 3))
- Thanks alot for your help with this!
