muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi all...
how to calculation date with number then the final result is in still date format (dd/mm/yyyy)
like this sample
not use macro/vba
any help, thank in advance
.sst
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