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.
Now, letâs understand how to use DATEDIF function in excel. Objective: Letâs, consider our objective is to find the number of days from 14 April 1912 (The day on which Titanic Sank) till todays date. So, we will try to apply the DATEDIF formula. âStart_Dateâ: In this case our âStart_Dateâ will be: 14 April 1912. âEnd_Dateâ: End_Date will be todayâs date. So, instead of entering the todayâs date manually we will use the Today() function. âUnitâ: As we want to find the number of days between the period.