Managing dates using the DAY() function

Excel treats dates as numbers so it’s easy to add and subtract dates to find the day that 36 days in the future or 15 in the past. Unfortunately, some other calculations aren’t so simple. For example, you might want to calculate the date an employee’s benefits start based on their hire date. If they were hired on March 15, the effective date would be March 1; if they were hired on March 16, the effective hire date would be April 1. Rather than create a complicated formula to do that math, I’ll show you a simpler method using the DAY() function.
You can download the sample file from www.curtisfrye....
If you’d like to support my work here, please buy me a coffee or two through Ko-fi!
ko-fi.com/tech...

[@charliemather3368]

Didn't realize the DATE function would properly handle the subsequent year and month for a December date!

[@techsoc]

I didn't either until I tried it. Good thinking on the part of the Excel team!