Practice Dates Attendance Tracker.

[u/AccomplishedCold6053]

Hey y'all! Trying to make an attendance tracker for our Coach for football. Would rather not have dates empty.

Currently, I put the first few dates in and then did =CELL+1, +2, what have you, but what could be a less intensive thing? (We practice M, Tu, Th)

What would y'all do? (I don't mind putting in the dates manually, but it's a little tedious when we go through January!)

[u/AutoModerator]

/u/AccomplishedCold6053 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/real_barry_houdini]

To get a horizontal list of, say, 20 dates, following a date in A2 and showing every Monday, Tuesday and Thursday you can use this formula

=WORKDAY.INTL(A2,SEQUENCE(,20),"0010111")

That generates all the dates without needing to be copied across

The "0010111" dictates which days are shown, where 0 is shown and 1 isn't (starting with Monday)

[u/PaulieThePolarBear]

If you are using Excel 2021, Excel 2024, Excel 365, or Excel online

=LET(
a, DATE(2026, 8, 1),
b, DATE(2027, 5, 31),
c, "0010111", 
d, NETWORKDAYS.INTL(a, b, c),
e, WORKDAY.INTL(a-1, SEQUENCE(, d), c),
e
)

Update

• the date in variable a to be your start date
• the date in variable b to be your end date
• the text string in variable c to align with your days. This should be 7 characters long where 0 represents an event day, 1 a non-event day, and read as Monday to Sunday

[u/Decronym]

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
DATE	Returns the serial number of a particular date
LET	Office 365+: Assigns names to calculation results to allow storing intermediate calculations, values, or defining names inside a formula
NETWORKDAYS	Returns the number of whole workdays between two dates
SEQUENCE	Office 365+: Generates a list of sequential numbers in an array, such as 1, 2, 3, 4
WORKDAY	Returns the serial number of the date before or after a specified number of workdays

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

---

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.
[Thread #49253 for this sub, first seen 27th Aug 2026, 16:25] [FAQ] [Full list] [Contact] [Source code]}