Excel Formula - Count Number Of Days Between Two Dates Today

In this video, I will show you how to used the excel DAYS() formula to count the number of days between two dates from today

Do you ever need to know how many days are between two dates? If so, you can use the DAYS() function in Excel to make the calculation of days between dates easy. By entering the two dates into a worksheet cell and then using the DAYS() function, you can return the number of days between those dates. The DAYS() function can be useful for calculations such as determining how long it will take for a project to be completed or how long ago an event occurred. Let’s look at how to use this function as I walk you through an example.

If you want to read the corresponding blog post you can do so below.

𝐉𝐨𝐢𝐧 𝐭𝐡𝐨𝐮𝐬𝐚𝐧𝐝𝐬 𝐨𝐟 𝐨𝐭𝐡𝐞𝐫 𝐄𝐱𝐜𝐞𝐥 𝐮𝐬𝐞𝐫𝐬 𝐰𝐡𝐨 𝐡𝐚𝐯𝐞 𝐚𝐥𝐫𝐞𝐚𝐝𝐲 𝐣𝐨𝐢𝐧𝐞𝐝 𝐭𝐡𝐞 𝐄𝐱𝐜𝐞𝐥 𝐀𝐭 𝐄𝐱𝐜𝐞𝐥 𝐌𝐨𝐧𝐭𝐡𝐥𝐲 𝐍𝐞𝐰𝐬𝐥𝐞𝐭𝐭𝐞𝐫. 𝟑 𝐅𝐑𝐄𝐄 𝐄𝐱𝐜𝐞𝐥 𝐓𝐢𝐩𝐬 𝐞𝐯𝐞𝐫𝐲 𝐦𝐨𝐧𝐭𝐡. 𝐏𝐥𝐮𝐬 𝐅𝐑𝐄𝐄 𝟑𝟎 𝐓𝐢𝐩𝐬 𝐄𝐁𝐨𝐨𝐤.

𝐡𝐭𝐭𝐩://𝐰𝐰𝐰.𝐡𝐨𝐰𝐭𝐨𝐞𝐱𝐜𝐞𝐥𝐚𝐭𝐞𝐱𝐜𝐞𝐥.𝐜𝐨𝐦/𝐧𝐞𝐰𝐬𝐥𝐞𝐭𝐭𝐞𝐫-𝐬𝐢𝐠𝐧-𝐮𝐩/

𝐁𝐞 𝐒𝐨𝐜𝐢𝐚𝐥 & 𝐋𝐞𝐭❜𝐬 𝐂𝐨𝐧𝐧𝐞𝐜𝐭
👍𝐖𝐞𝐛𝐬𝐢𝐭𝐞 𝐡𝐭𝐭𝐩://𝐰𝐰𝐰.𝐡𝐨𝐰𝐭𝐨𝐞𝐱𝐜𝐞𝐥𝐚𝐭𝐞𝐱𝐜𝐞𝐥.𝐜𝐨𝐦
👍𝐓𝐰𝐢𝐭𝐭𝐞𝐫 𝐡𝐭𝐭𝐩𝐬://𝐭𝐰𝐢𝐭𝐭𝐞𝐫.𝐜𝐨𝐦/𝐡𝐨𝐰𝐭𝐨𝐞𝐱𝐜𝐞𝐥𝐚𝐭𝐞𝐱

My Recommended Excel Courses

[wayneedmondson]

Hi Barbara. Great tip to use the DAYS() function. Since dates are serial numbers, usually I just subtract the end_date from the start_date or in your example it would be =C2-TODAY(). Using DAYS() maybe makes it a little more clear for a user that does not understand the serial nature of EXCEL dates. Thanks for sharing! Thumbs up!!

[silverlicious]

Hi. It's funny you posted this. Just last week I wanted to know how many days it was until a deadline date. I didn't know about the DAY function. So all I did was have a cell, say C5. It has the deadline date of Feb 28, 2022. The format of this cell is MM/DD/YYYY. Then in cell D5 I have a simple formula: =C5-TODAY(). The format of cell D5 is Number, no decimal points. The result in cell D5 shows 20. That is 20 days until the deadline. And like you, I use TODAY to make it dynamic. But thanks for posting this about DAYS. I never knew about this function.

[Win-xo]

Great! it is practically used for me to count number of days left before Expiry Date at my Pharmacy. Is there any specific meaning for "()"?

[sunkissedangel]

how do you calculate number of days from column C to today? I cannot figure it out.

[a_a_ron_]

If both of your dates are not referenced in a cell, you can use =DATE(YYYY, MM, DD)-DATE(YYYY, MM, DD) for example if you want to calculate the number of days between today and a date in the past you can use =TODAY()-DATE(YYYY, MM, DD)