1. Excel Tips - How many days until Christmas ?
This example will show you how to calculate the number of days between now and christmas.
- In a cell A1 in a new workbook, press: CTRL + ;
- That will put today's date in the cell
- In cell A2 type: 25/dec
- Excel will correctly guess the year
- In cell A3 type: =A2-A1
- Press CTRL + SHIFT + # to format the cell as a number
- So from today, there are 6 days until Christmas
Festive greetings !
Training Video on Calculating the difference between 2 dates: