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
- 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 again
