Forum Discussion
Solved
Excel date + number function
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
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.
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
I understand, thank you very much!
Best regards
Tuomo