Members lesson 28
Dates
Build dates, extract date parts, and measure calendar and working time.
What you will practice
- Build and inspect dates
- Find a month end and count working days
- Measure complete months with DATEDIF
Lesson preview
Starting tableSchedule dates
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Task | Start value | End or month | Day or holiday | Date result | Value | |
| 2 | Build a date | 2,025 | 2 | 14 | |||
| 3 | Read date parts | 7/15/2024 | |||||
| 4 | Month end | 2/10/2024 | |||||
| 5 | Working days | 1/1/2024 | 1/8/2024 | 1/3/2024 | |||
| 6 | Complete months | 1/15/2024 | 4/15/2024 |