Over the years, I’ve made a lot of forms in Excel. I always aim for something simple and clean. If something is going to get complicated, it’s likely because the form has a date. Dates are always a challenge because there’s not the same number of days in every month, and not even the same number of days in every year.
Just the other day, I ran across the =eomonth() function. All it does is give you the last day of a month. It’s brilliant. I’m not sure how long this function has been around. Before this, I would always calculate the first day of the next month and subtract a day.
In the video, I show you how I use it. I’m also giving you my practice Timesheet (linked below).
The function is simply this: =eomonth(start_date, months)
Let’s say you have 9/13/24 in cell A1. Here’s how that function would work:
- eomonth(A1,0) = 9/30/24
- eomonth(A1,3) = 12/31/24
- eomonth(A1,60) = 9/30/29
- eomonth(A1,-2) = 7/31/24
Useful Links
- Timesheet Example: https://jctaccounting.com/wp-content/uploads/2024/09/Time_Sheet_Example.xlsx
- Microsoft Instructions: https://support.microsoft.com/en-us/office/eomonth-function-7314ffa1-2bc9-4005-9d66-f49db127d628