Have you ever wanted to see how many days were left in the year? I know I always wanted to especially when I was little. The smaller the number the closer it was to the holidays, and I love the holidays. For what every reason you want to know there is a quick and easy way to do this. Here is a quick Excel how to for calculating the remaining days in the year.
Calculate Remaining Days in the Year
Open up Excel and enter “=today()” into A1. The Today function lets you display the current date and time into any given cell.
Then enter this formula into A2 “=Date(YEAR(A1),12,31)-A1” without the quotes. So lets take a look at the formula we just entered. the first one is the Date function. This returns the sequential serial number that represents a particular date. By sequential serial number we mean if we had the date 7/8/2008 we would see 39637 if we used the Date function. The syntax for it is =Date(Year,Month,Day). We are also using the Year function. This finds the year in a date and returns that value. So for 7/8/2008, the Year function would return 2008. When we combine these two for the formula in A2, we are taking the Year from A1, with 12 as month, and 31 as the day, then converting those numbers into a date, 12/31/2010 then subtract it from A1 to give use the remaining days in the year.
You can also get a little creative with it and do some formatting.
Just save the file something you want and you will always have a count down counter to the New Year. After the first of the year, it will automatically restart the count down so you don’t have to worry about updating anything.
If you like this Excel how to, then check out our other ones like how to calculate loan payoff, remove hidden shapes and objects, or password protect Excel workbook.
Comments are closed.