So it is a short and snappy #formulafriday today, there are only two arguments to this Function
So it is fairly simple, Excel will calculate the number of days between two dates. Let’s take a look at an example using some sporting dates.
I am a tennis fan, so let’s see how many days I have to wait until the Wimbledon Championship begins from today 10 June 2016,….. oh and not to be too Tennis biased I also included the start of the 2016 Olympic Games!
So as we can see, the end_date argument references E4 which contains the date of Wimbledon and the start_date is referenced using TODAY() which uses today’s date. In this way every day, the formula will update with the number of days until the tournaments. Easy.
There we go, once of the newer Functions available from Excel 2013. Useful.
Dont forget to SUBSCRIBE to the How To Excel At Excel Newsletter for more tips the first Wednesday of the month.
- Create A Timestamp In Excel
- Hide all of your Excel formulas from prying eyes!
- Undertand and debug Excel formula errors
- How To Display a Plus + Sign On Positive Numbers With Custom Formatting In Excel