What does it do?

Gets the day from the date

Formula breakdown:


What it means:

=DAY(date wherein the day will be extracted from)

I recall wherein I had a lot of dates and I wanted to extract the day of the dates one-by-one… It was too much of a hassle! Thankfully there is Excel’s DAY Formula to do that for me!

I explain how you can do this below:

DAY Formula in Excel | MyExcelOnline


STEP 1: We need to enter the DAY function in a blank cell:


DAY Formula in Excel


STEP 2: The DAY arguments:


What is the date that you want to extract the day from?

Select the cell containing the date:


DAY Formula in Excel

Apply the same formula to the rest of the cells by dragging the lower right corner downwards.

DAY Formula in Excel

You now have your days extracted!

DAY Formula in Excel


How to Use the DAY Formula in Excel




DAY Formula in Excel | MyExcelOnline


If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn