abdelfattah
Well-known Member
- Joined
- May 3, 2019
- Messages
- 1,429
- Office Version
- 2019
- 2010
- Platform
- Windows
hello
i need formula to specific date after calculate 12 months so i have date in column a and the result in column b so it a2 = 1/7/2019 and when add 12 months when date reaches before finish day it shows in b2 =1/7/2020 it supposes showing this date when date of computer becomes 30/06/2020 i would this formula is dynamic because i have many dates
input
output
i need formula to specific date after calculate 12 months so i have date in column a and the result in column b so it a2 = 1/7/2019 and when add 12 months when date reaches before finish day it shows in b2 =1/7/2020 it supposes showing this date when date of computer becomes 30/06/2020 i would this formula is dynamic because i have many dates
input
1 .xlsm | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | CURRENT DAY | A NEW DATE | ||||
2 | 01/07/2019 | |||||
3 | 15/05/2018 | |||||
4 | 10/01/2011 | |||||
5 | ||||||
6 | ||||||
sheet3 |
output
1 .xlsm | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | CURRENT DAY | A NEW DATE | |||||
2 | 01/07/2019 | 01/07/2020 | |||||
3 | 15/05/2018 | 15/05/2019 | |||||
4 | 10/12/2011 | 10/12/2011 | |||||
5 | |||||||
6 | |||||||
sheet3 |