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 Days360 Function in Excel. When you want to work out how many days there are between two dates, the function to use is Days360( ). We want to work out how many days there are between the 15th of April 2016 and the 3rd of May 2016. So click inside cell C2 and do the following: Click on the Formulas tab at the top of Excel.