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 423 views

## 1 answer to this question.

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