Holiday Weather - We provide weather averages for Florida Keys USA, average day and night temperature, sunshine hours, rainfall and sea temperature Holiday Weather Search :
The Microsoft Excel DAY function returns the day of the month (a number from 1 to 31) given a date value. The DAY function is a built-in function in Excel that is categorized as a Date/Time Function. It can be used as a worksheet function (WS) and a VBA function (VBA) in Excel. As a worksheet function, the DAY function can be entered as part of a formula in a cell of a worksheet. As a VBA function, you can use this function in macro code that is entered through the Microsoft Visual Basic Editor.
Enter a date reference in a cell. For this example, we'll use the date 11/7/2012.. In A1, enter that date. Ad. 2. Calculate the abbreviated weekday name. In cell B1, enter =TEXT((A1), ddd) into the cell or formula field. 1  The ddd setting tells Excel to use the first three letters of the weekday name.