•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to when entering month have the day and date change
Our take
If you're looking to automatically update the days of the week and their corresponding numerical dates when entering a month and year, you're not alone. Many users encounter this challenge on timesheets, particularly when inputting dates like "May 2026." Fortunately, with the right formula or settings in your spreadsheet, you can streamline this process. Let's explore how to set up your timesheet so that both the day of the week and the numerical date adjust automatically when you enter the month and year.
On my timesheet I input the month and year 'May 2026' and when this happens I need the column with days of the week and then adjacent column with the numerical date (1, 2 etc) to then change.
Please I cannot figure it out
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#financial modeling with spreadsheets#rows.com#Excel compatibility#Excel alternatives for data analysis#Excel alternatives#timesheet#May 2026#month#year#days of the week#numerical date#Excel#input#change#formula#column#adjacent column#calendar#weekdays#figure it out