Forum Discussion
Calculating Number of Months Before/After a Specific Date Between Two Dates
Operating System: Windows 10 Version 20H2, 64-bit operating system Excel Product: Microsoft Office Professional Plus 2016 I hope everyone is having a good day and thanks in advance for all those...
aagoldman Attached a possible solution for you. not very straight-forward and certainly not very pretty. But, I think it works as intended. I've introduced a few names ranges to keep the formulae easier to follow.
Riny_van_Eekelen Thank you! This seems functional and produces the results I was looking for. Now, I will try to examine the formula and try to understand it so I can explain it to my colleagues. I really appreciate your assistance.
aagoldman Glad it worked. And when you examine the formula, break it down in smaller pieces and see what every part is "doing". Not very straight-forward, I must admit. Come back here if you need more help.
