PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

CONTENTS

EXCEL FUNCTIONS-DAY

INTRODUCTION

DAY function comes under the DATE AND TIME FUNCTIONS category in Excel.

DAY FUNCTION returns the DAY NUMBER(1 TO 31) from a sequential date.

THIS PARTICULAR FUNCTION IS USED FOR ANY SITUATION WHERE WE NEED TO EXTRACT THE DAY FROM  SEQUENTIAL NUMBER OF THE DATE.

PURPOSE OF DAY FUNCTION IN EXCEL

DAY FUNCTION returns the DAY NUMBER from a GIVEN SEQUENTIAL date.

PREREQUISITES TO LEARN DAY FUNCTION

THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.

 

  •  Basic understanding of how to use a formula or function.
  •  Basic understanding of rows and columns in Excel.
  • Some information about the financial terms is an advantage for the use of such formulas.
  •  Of course, Excel software.
Helpful links for the prerequisites mentioned above

SYNTAX: DAY FUNCTION

The Syntax for the function is

=DAY(DATE IN SEQUENCE NUMBER OF ENTERED VIA DATE FUNCTION)

DATE IN SEQUENCE NUMBER We know that the date is stored as a sequence number counted from JAN 1 1900.

IT can also be done if we enter DATE by DATE FUNCTION.

EXAMPLE:DAY IN EXCEL

DATA SAMPLE

THE TWO CASES HAVE BEEN DISCUSSED.

CASE 1:

The date is a sequence number.

 

CASE 2:

The date entered by DATE FUNCTION.

 

 

 

EXCEL: FUNCTION DAY EXAMPLE

STEPS TO USE DAY FUNCTION

The dates have been given in G7 AND G9.
The functions has been used are shown in the picture itself.
The function for CASE 1 is
=DAY(G7)
and
The function for CASE 2 is
=DAY(G9)
The RESULT shows the value as 26 for CASE 1 as the date for the sequence number 45652 is
and for the CASE 2 its obvious that DAY is 20.

CONFUSION CLARIFICATIONS

SEQUENTIAL NUMBER OF DATE

The date in EXCEL is stored as a sequential number which starts from JAN 1 1900. i.e.

the date JAN 1 1900 will be stored as 1 in Excel.

*The same for the MAC is stored as JAN 1 1904.

 

 

OTHER WAYS TO REACH THIS ARTICLE

  • DAY FUNCTION, HOW TO FIND THE DAY OF THE MONTH, DAY NUMBER OF THE MONTH

YOU MAY LIKE

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

gyankosh060309@gmail.com

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: