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.
1 Excel's DATEDIF Function If you regularly work with dates and times in Excel, then it is worth learning how some of Excel's date-related functions operate. 2  There are over 20 functions in this group, â¦. 3  How to Quickly Sum a Column in Excel SUM is one of the commonly used functions in Excel. One of the most useful functions in Excel is the IF function. What it does is test a value in a specific cell to see if that value meets a certain condition. If the valu â¦ e does meet the condition, one result will happen, if false, a different action will occur.