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

Use the DATEDIF function when you want to calculate the difference between two dates. First put a start date in a cell, and an end date in another.

Calculate age in accumulated years, months, and days

1. Use DATEDIF to find the total years. 
2. Use DATEDIF again with “ym” to find months. 
3. Use a different formula to find days.