DAY(text) converts to a day of the month : DAY « Statistical functions « Microsoft Office Excel 2007 Tutorial






Input the formula: =DAY("15-Apr-2008"). Press Enter to get the result.
Input the formula: =DAY(15-Apr-2008)
21.19.DAY
21.19.1.DAY(text) converts to a day of the monthDAY(text) converts to a day of the month