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?

Nov 7, 2022 in Others 449 views

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.
• 23,260 points

Creating a function in excel VBA to calculate the average point in a circular set of numbers

I used the following code to determine ...READ MORE

How do I combine the first character of a cell with another cell in Excel?

Try this: =CONCATENATE(LEFT(A1,1), B1) READ MORE

MS Excel showing the formula in a cell instead of the resulting value

Make sure that... There's an = sign before the formula There's ...READ MORE

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

Forget the PsychoPy complications for the time ...READ MORE

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

Change date format of cell in excel from dd.mm.yyyy to yyy/mm/dd ( excel version 2013 )

Hello :)   Excel’s Format Cells function can quickly ...READ MORE