Microsoft Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1797990%22%20slang%3D%22en-US%22%3EMicrosoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1797990%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20want%20to%20formulate%20date%20i.e%20adding%20date%20or%20subtracting%20date%2C%20like%2020%2F10%2F2020%20and%2018%2F10%2F2019.%20How%20i%20can%20add%20or%20subtract%20complete%20date%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1797990%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1798337%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1798337%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F838681%22%20target%3D%22_blank%22%3E%40arslan_uaf%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESubtracting%20dates%20is%20easy%3A%20let's%20say%20the%20first%20date%20is%20in%20A1%20and%20the%20second%20date%20in%20B1.%3C%2FP%3E%0A%3CP%3EIn%20another%20cell%2C%20enter%20the%20formula%20%3DB1-A1%20and%20format%20the%20cell%20as%20General.%3C%2FP%3E%0A%3CP%3EThe%20cell%20will%20display%20the%20number%20of%20days%20between%20the%20dates.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAdding%20two%20dates%20makes%20no%20sense.%20But%20you%20can%20add%20a%20number%20of%20days%20to%20a%20date.%3C%2FP%3E%0A%3CP%3ELet's%20say%20you%20have%20a%20date%20in%20A1%2C%20and%20you%20want%20to%20add%207%20days%20to%20get%20the%20date%20a%20week%20later.%3C%2FP%3E%0A%3CP%3EUse%20the%20formula%20%3DA1%2B7%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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
Highlighted

@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