Photo by Rob OâNeal/Florida Keys Tourist Development Council. Wherever you are right now, chances are the weather is better here in the Florida Keys. Thatâs true even on a summer day. The hottest itâs ever been in Key West is 97Â° F (36Â° C), and that was way back in 1880. At the peak of summer, the average high is 89Â° F (32Â° C).
To count the days before a date, you can use the TODAY function. Example. The example may be easier to understand if you copy it to a blank worksheet. Create a blank workbook or worksheet. Select the example in the Help topic. Note: Do not select the row or column headers.
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.