ClwnMan76
New Member
- Joined
- Oct 26, 2009
- Messages
- 28
- Office Version
- 365
- Platform
- Windows
I found the right formula I need on a site (that didn't explain it ). Between this and other examples, I can't piece enough together to wrap my head around it. Two hours of googling and I'm done!
This gives me the first Monday (obviously you probably already know that) and I'm wanting to adapt it to Thursday. I understand the Date part. I get the rest, but really how they work together. If someone has time to explain that would be AWESOME! If not, a simple modification on how to adapt to to be Thursday instead would be appreciated!! BTW.... B2 has a year in it (2019).
=DATE(B2,1,1)+CHOOSE(WEEKDAY(DATE(B2,1,1),2),0,6,5,4,3,2,1)
This gives me the first Monday (obviously you probably already know that) and I'm wanting to adapt it to Thursday. I understand the Date part. I get the rest, but really how they work together. If someone has time to explain that would be AWESOME! If not, a simple modification on how to adapt to to be Thursday instead would be appreciated!! BTW.... B2 has a year in it (2019).
=DATE(B2,1,1)+CHOOSE(WEEKDAY(DATE(B2,1,1),2),0,6,5,4,3,2,1)