Calculation Date with Number

[muhammad susanto]

hi all...

how to calculation date with number then the final result is in still date format (dd/mm/yyyy)
like this sample

Book1
	F	G	H
2	date (dd-mm-yyyy)	number (given)	after formula
3	23/10/2020	5	23/10/2025
4	09/12/2016	3	09/12/2019
Sheet1

not use macro/vba
any help, thank in advance
.sst

 

[Joe4]

Use this formula:

=EDATE(F3,G3*12)

Note that you just need to apply whatever date format you want to the cell to get it to display that way.
Excel stores all dates as numbers. So dates are just specially formatted numbers in Excel.

 

[muhammad susanto]

hi Joe4, work great, thank
1 question, how if subtract number like this
23/10/2020 - 5 =23/10/2015

 

[Joe4]

1 question, how if subtract number like this
23/10/2020 - 5 =23/10/2015

It is simpler than you think (I bet you could have figured it out). Just add a negative to the formula.

=EDATE(F3,-G3*12)

Don't be afraid to try these things out for yourself!
It is usually the best way to learn!