DAY Function in Excel

Home/Excel Formulas/DAY Function in Excel

What is the use of DAY function?

Returns the day of the month represented by a serial number.
Note:The day is given as an integer ranging from 1 to 31.

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

BROWSE ALL TEMPLATES

50+ Project Management Templates Pack
Excel PowerPoint Word

VIEW DETAILS

Advanced Project Plan & Portfolio Template
Excel Template

VIEW DETAILS

Business Presentations Templates Pack
PowerPoint Slides

VIEW DETAILS

20+ Excel Project Management Pack
Excel Templates

VIEW DETAILS

20+ PowerPoint Project Management Pack
PowerPoint Templates

VIEW DETAILS

10+ MS Word Project Management Pack
Word Templates

VIEW DETAILS


What is the syntax of DAY function?

DAY Function and Formula in Excel -syntax

DAY(serial_number)

Where serial_number: Is a number of the day
Serial_number is the date of the day you want to find.

DAY Function in Excel – Examples

DAY Function and Formula in Excel - Example

Reference:

Please refer the below article for more Date & Time Excel functions.
Date & Time Excel Formulas

Please refer the below article for more Excel Functions.
Excel Formulas | Home

LIMITED TIME OFFER - Get it Now!
Advanced Project Plan Excel Template
LIMITED TIME OFFER - Get it Now!
Business PowerPoint Presentations Templates Pack
 
 
Related Resource External VBA Reference
By |June 4th, 2013|Excel Formulas|0 Comments

About the Author:

Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, reports generation and dashboards preparation. Valli is sharing to helps us automating daily tasks.

Leave A Comment