Hi guys,
it's been ages since I had to post a question on Excel.
I hope a good Samaritan will be able to assist
Basically I have contracts with a starting date and an end date.
These contract scan be for 1, 3, 6 12, 24, 36 months
A1 : 6/1/2019
A2 : 12/31/2021
A3 : 30 (months)
I would need in Cell A5, A6, A7 to have the number of months of live contracts calculated (ie: A5 : 6, A6 : 12, A7: 12)
Has anyone an idea on how to create a formula for this please?
Thank you
it's been ages since I had to post a question on Excel.
I hope a good Samaritan will be able to assist
Basically I have contracts with a starting date and an end date.
These contract scan be for 1, 3, 6 12, 24, 36 months
A1 : 6/1/2019
A2 : 12/31/2021
A3 : 30 (months)
I would need in Cell A5, A6, A7 to have the number of months of live contracts calculated (ie: A5 : 6, A6 : 12, A7: 12)
Has anyone an idea on how to create a formula for this please?
Thank you