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 result: 372 Months. To calculate the number of days from the date, enter the following formula in cell E1:=DATEDIF(A1,TODAY(),âdâ) The result: 11333 Days. PS: A lot of site, avoid calculating date in Excel using DATEDIF function. The reason is âbugsâ. DATEDIF function doesnât have any documentation in Excel Help file.