Beautiful Day: Finding The Day Of The Month In Excel


In your life and mine, there are certain days of every month that hold some special significance.  You know... pay day, trash day, dog washing day, and so on!

Excel gives us the DAY() function as a way of referencing a date...

And returning a number corresponding to the day of the month.

So if we wanted to create a simple IF conditional that checked to see if a date is in the first seven days of a month...

We simply use the DAY() function to check if the number returned is less than 8.

Need additional help with DAY(), dates, or other Excel elements?  Reach out today via live chat, email, or phone!