Good day Excel geniuses!
I'm attempting to create a weekly savings planner using a few pirated elements from other excel stuff I've found on the web. As you can see in col. J&K and P&Q you have the week number and a corresponding date. In this case the dates are the Thursdays within each month (huzzah payday!). The intent/end goal here is to input the year into N1 and T1, which would then flow down into the K and Q columns and change them according to the year, listing out the Thursdays ONLY.
To the right of the columns you can see an example of what I would like the aforementioned columns to do (sorta).
What I understand:
'CalendarYear1' or 'CalendarYear2' link back to the date in N1 or T1 respectively (right now the example is set to T2) and their subsequent names in the Name Box.
I understand that arrays need Ctrl+Shift+Enter to implement.
The formula in the example on the dates (array):
=DaysAndWeeks+DATE(CalendarYear2,1,1)
Breakdown of said forumla as I understand it:
=: duh. It's the start of the formula
DaysAndWeeks: a defined name?
+Date: addition of the date function as excel interprets the numbers (I understand how excel counts up from 1/1/1900)
(CalendarYear2: Start of the DATE formula, looks at the cell with the applied Name of CalendarYear2.
1,1): End of the formula that displays Year and Month (or Month and Day, but I get what it's kicking out)
Million dollar Question:
1) How do I adjust the formula/array to only yield the Thursdays found in each month?
I've had a lot of luck in the past with my GoogleFu, but this question is fairly specific and I'm not sure how to approach it. I did find a function in my search of =SEQUENCE, however that seems only available to Excel 365 and I am running Excel 2013.
Bookmarks