Walker_Ice
Board Regular
- Joined
- Oct 6, 2023
- Messages
- 50
- Office Version
- 2021
- Platform
- MacOS
Hi Everyone,
I have this formula (See Below) to tell me which days of the week is most popular.
But now I am trying to figure out how can I go into my date column "Income_Dates" and find out if the appointments are in the 1st, 2nd, 3rd, 4th, or 5th week of the month. Trying to figure out which week is the most popular for booking appointments. Is it towards the end of the month or the beginning of the month.
Any help would be appreciated.
WeekDay-Formula:
=QUERY({ArrayFormula(TEXT(Income_Dates, "dddd")), Income_Dates}, "SELECT Col1, COUNT(Col2) WHERE Col1 is not null GROUP BY Col1 LABEL COUNT(Col2) ''")
I have this formula (See Below) to tell me which days of the week is most popular.
But now I am trying to figure out how can I go into my date column "Income_Dates" and find out if the appointments are in the 1st, 2nd, 3rd, 4th, or 5th week of the month. Trying to figure out which week is the most popular for booking appointments. Is it towards the end of the month or the beginning of the month.
Any help would be appreciated.
WeekDay-Formula:
=QUERY({ArrayFormula(TEXT(Income_Dates, "dddd")), Income_Dates}, "SELECT Col1, COUNT(Col2) WHERE Col1 is not null GROUP BY Col1 LABEL COUNT(Col2) ''")