The issue I am seeing with that formula is the referenced date in C1 starts in the middle of the month. So I have to start at that day, subtract to the left and add to the right. Then the days become inaccurate moving forward.



So, in the updated spreadsheet that I've attached, I made some changes. I have created tabs for each quarter as well as a 'Reference' tab where I put the first day of the year (Tuesday, January 1, 2019). I am using that reference cell with the formula =TEXT(WEEKDAY(Reference!$A1),"DDD"), which seems I will have to add (+1, +2, etc.) manually for each cell in row 4, unless I can find a way to auto-populate.

What I would like to do is find formulas that will automatically (and accurately) populate rows 3 and 4 (in that format) for each month. And having it account for leap years would be a huge bonus!!

Attached Files

Platoon T2T for 3-6 AMDTD.xlsx (135.2 KB, 9 views)