View Single Post
 
Old 05-19-2019, 11:15 AM
kelwea kelwea is offline Mac OS X Office 2016
Novice
 
Join Date: Jan 2017
Posts: 5
kelwea is on a distinguished road
Default @alansidman

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
File Type: xlsx Platoon T2T for 3-6 AMDTD.xlsx (135.2 KB, 7 views)
Reply With Quote