DATE(sl no)
- where 'sl no' 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.
- Here SL.NO is the date of the day and the dates are should entered in a DATE function format.
- i.eDATE(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