Calculate the number of days between a cell and today in excel

Question

How does one calculate the number of days between a cell with a date and today?

I've tried:

=B2-TODAY() 
=(B2)-TODAY()
=(B2-TODAY()).days
etc...

and am having no luck. How do I get the difference between cell B2 and today, in number of days?

Answer 1

Excel Formula to Calculate Number of Days Between Today and Another Date (6 Quick Ways)

1. =TODAY()-Cell(another date)
2. DAYS(end_date, start_date)
3. =DATE(year, month, day)-DATE(year, month, day)
4. DATEDIF(start_date,end_date, holidays)
5. =NETWORKDAYS(start_date, end_date, holidays)