Duration: 1:58

3 views

0

Here's how to subtract a Date from Today in Excel.

i. To subtract one date from another to get the number of days in Excel, you can use the DATEDIF function. The DATEDIF function takes three arguments: the start date, the end date, and the unit of measurement. The unit of measurement can be days, months, or years.

For example, to find the number of days between today and January 1, 2023, you would use the following formula:

```
=DATEDIF(TODAY(), "2023-01-01", "d")
```

This formula would return the number of days between the current date and January 1, 2023.

Here is a table of the different units of measurement that can be used with the DATEDIF function:

| Unit of measurement | Description |
|---|---|
| d | Days |
| m | Months |
| y | Years |

You can also use the DATEDIF function to find the number of working days between two dates. To do this, you need to specify the "wd" unit of measurement. The "wd" unit of measurement will exclude weekends and holidays.

For example, to find the number of working days between today and the end of the month, you would use the following formula:

```
=DATEDIF(TODAY(), "31-06-2023", "wd")
```

This formula would return the number of working days between the current date and the end of June 2023.

The DATEDIF function is a powerful tool that can be used to calculate the difference between two dates in Excel. It can be used to calculate the number of days, months, or years between two dates, as well as the number of working days between two dates.

ii. The formula for date difference is:

```
=DATEDIF(start_date, end_date, unit)
```

Where:

* `start_date` is the start date.
* `end_date` is the end date.
* `unit` is the unit of measurement for the date difference. The possible values for `unit` are:
* `d` for days
* `m` for months
* `y` for years

For example, to calculate the number of days between today and January 1, 2023, you would use the following formula:

```
=DATEDIF(TODAY(), "2023-01-01", "d")
```

This formula would return the number of days between the current date and January 1, 2023.

Here is a table of the different units of measurement that can be used with the DATEDIF function:

| Unit of measurement | Description |
|---|---|
| d | Days |
| m | Months |
| y | Years |

You can also use the DATEDIF function to find the number of working days between two dates. To do this, you need to specify the "wd" unit of measurement. The "wd" unit of measurement will exclude weekends and holidays.

For example, to find the number of working days between today and the end of the month, you would use the following formula:

```
=DATEDIF(TODAY(), "31-06-2023", "wd")
```

This formula would return the number of working days between the current date and the end of June 2023.

The DATEDIF function is a powerful tool that can be used to calculate the difference between two dates in Excel. It can be used to calculate the number of days, months, or years between two dates, as well as the number of working days between two dates.