Excelteacher21
New Member
- Joined
- Nov 22, 2021
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
Please help a teacher. It's my first year teaching Excel. Found an article where it explains how to calculate Thanksgiving date in any given year using the formula =DATE(Y,M,1+7*Nth)-WEEKDAY(DATE(Y,M,8-DoW). I want to teach this to my students TOMORROW but can't remember why 1+7. Where do we get that or why do we use that? And where do we get the "8" in 8-DoW). All other parts of the formula I understand and can explain to my students. I passed certification in 2013 but my Excel is rusty. If anyone could answer those 2 questions, I'd appreciate it.