Difference between revisions of "Manuals/calci/DAY"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
<div style="font-size:30px">'''DAY(sl.no)'''</div><br/> | <div style="font-size:30px">'''DAY(sl.no)'''</div><br/> | ||
*where <math>sl.no</math> is the date of the day to find. | *where <math>sl.no</math> is the date of the day to find. | ||
| − | |||
==Description== | ==Description== | ||
*This function gives the day of the month and also the day is from 1 to 31. | *This function gives the day of the month and also the day is from 1 to 31. | ||
*<math>sl.no</math> is the date of the day and the dates should be entered in the DATE function format. | *<math>sl.no</math> is the date of the day and the dates should be entered in the DATE function format. | ||
| − | *i.e DATE(2014,1,7) for 7th day of January, 2014. | + | *i.e [[DATE]](2014,1,7) for 7th day of January, 2014. |
*so we have to use this function like DAY("7-JAN-2014") or DAY("1-7-2014") is 7 | *so we have to use this function like DAY("7-JAN-2014") or DAY("1-7-2014") is 7 | ||
Revision as of 00:31, 20 November 2013
DAY(sl.no)
- where is the date of the day to find.
is the date of the day to find.Description
- This function gives the day of the month and also the day is from 1 to 31.
- is the date of the day and the dates should be entered in the DATE function format.
- i.e DATE(2014,1,7) for 7th day of January, 2014.
- so we have to use this function like DAY("7-JAN-2014") or DAY("1-7-2014") is 7
Examples
- DAY("12/11/2013") = 11
- DAY("12-DEC-2012")=12
See Also