Microsoft Excel

Copper Contributor

Hi, I want to formulate date i.e adding date or subtracting date, like 20/10/2020 and 18/10/2019. How i can add or subtract complete date

 

1 Reply

@arslan_uaf 

Subtracting dates is easy: let's say the first date is in A1 and the second date in B1.

In another cell, enter the formula =B1-A1 and format the cell as General.

The cell will display the number of days between the dates.

 

Adding two dates makes no sense. But you can add a number of days to a date.

Let's say you have a date in A1, and you want to add 7 days to get the date a week later.

Use the formula =A1+7