1. Excel Tips - How many days until Christmas ?

This example will show you how to calculate the number of days between now and christmas.
Step1:
- In a cell A1 in a new workbook, press: CTRL + ;
- That will put today's date in the cell
Step2:
- In cell A2 type: 25/dec
- Excel will correctly guess the year
Step3:
- In cell A3 type: =A2-A1
Step4:
- Press CTRL + SHIFT + # to format the cell as a number
- So from today, there are 6 days until Christmas
Festive greetings !
Nick
Training Video on Calculating the difference between 2 dates:
»
- Nick's blog
- Login or register to post comments
- 19580 reads
Recent comments
5 years 51 weeks ago
6 years 37 weeks ago
6 years 49 weeks ago
6 years 51 weeks ago
7 years 5 days ago
7 years 6 weeks ago
7 years 14 weeks ago
7 years 14 weeks ago
7 years 15 weeks ago
7 years 15 weeks ago