Forum Discussion
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.
2 Replies
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
