List dates between a start & end date, day of the week & create a month-wise calendar-like view
Want to understand how to list dates between a start date and an end date, get the day of the week given a date (either a number from 1 to 7 or days from Monday to Sunday), or create a month-wise calendar-like view (that is list all Mondays in a month in a column, all Tuesdays in a month in next column and so on till Sunday) in Google Sheets? You have come to the right place, just watch this video and be productive :)
Added benefits of watching the video - know how to use
1. "SEQUENCE",
2. "DATEVALUE",
3. "DAY",
4. "MONTH",
5. "YEAR",
6. "SWITCH",
7. "CONCATENATE",
8. "FILTER",
9. "INDEX",
10. "MATCH",
11. "DATE",
12. "IF",
13. "IFERROR",
14. Data validation
15. Conditional formatting
in Google Sheets.
Link for Data Validation with dependent drop-down in Google Sheets video: • Data Validation - Dependent Drop-down in G...
Link for Data Validation with Tick Boxes in Google Sheets video:
• Data Validation with Tick Boxes in Google ...
Link for Conditional Formatting of a Row in Google Sheets video:
• Conditional Formatting of a Row in Google ...