SOLVED

Excel date + number function

%3CLINGO-SUB%20id%3D%22lingo-sub-2231860%22%20slang%3D%22en-US%22%3EExcel%20date%20%2B%20number%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2231860%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Excell%20Experts%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20you%20help%20me%20what%20is%20formula%20in%20excel%20date%20%2B%20number%20%3D%20date%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2024.3.2021%20%2B%201%2C5%20%3D%20new%20date%20in%20future%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%3C%2FP%3E%3CP%3ETuomo%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2231860%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi Excell Experts,

 

Could you help me what is formula in excel date + number = date ?

 

For example 24.3.2021 + 1,5 = new date in future ?

 

Best regards

Tuomo

2 Replies
best response confirmed by TuomoT (New Contributor)
Solution

@TuomoT The cool thing about dates in Excel is that the are in fact numbers. So you can calculate with them. Assuming that 24.3.2021 is recognised as a date by your local Excel settings and the comma as the decimal separator, you can enter a formula like =A1+1,5. It will will add 36 hours (i.e. one and a half day) to whatever date/time is in A1.

Hi Riny,
I understand, thank you very much!

Best regards
Tuomo