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.
Workday Function Examples. In the spreadsheets below, the Excel Workday function is used to find a date that is 25 work days after 01-Dec-2015. The first example (in cell A7) only excludes weekends from the calculation, while the second example (in cell A8) excludes weekends and a supplied list of holidays. Formulas:Results:asic Description. The Excel Workday function returns a date that is a supplied number of working days (excluding weekends and holidays) ahead of a given start date.