Excel Guides

Determining the Day of the Month in Excel

To determine the day of the month in Excel, you can use a variety of different formulas. The most common and simplest formula is =DAY(A1), where A1 is the cell containing the date. This formula will return the day of the month as a number from 1 to 31.

If you want to return the day of the week as a text string, you can use the formula =TEXT(A1,"dddd"). This will return the full name of the day, such as "Monday" or "Tuesday".

You can also use the WEEKDAY function to return a number representing the day of the week. The number returned will be between 1 (Sunday) and 7 (Saturday).

To get more detailed information about a particular day, you can use the DAYS function. This function will take a start date and an end date, and will return the number of days between those two dates. This can be useful if you want to know how many days are in a particular month, or if you want to calculate how many days have passed since a certain event.

Move beyond 


Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.