How to calculate the number of months between 2 dates
Simply, I need a formula to calculate the number of months a vehicle has been in service. I have a [In Service Date]. So I am thinking something like Today()-[In Service Date]=xxxMonths
Forum Discussion
Hey QB Team! I am seeking to do the same, calculate the number of months between a date and (today), looks like this thread addressed it but the URL above & referenced as a great solution is broken (says "Sorry! The page you requested was not found")
Can anyone share the formula?
Tied to this I am trying to look back at my company's sales by channel and get an average per month sales since their first sale, then make another field next to it that shows their sales in the last 30 days so my sales team can see if their account is declining or growing.
Thank you !
Bobby
------------------------------
Bobby Hollis
------------------------------
Can anyone share the formula?
Tied to this I am trying to look back at my company's sales by channel and get an average per month sales since their first sale, then make another field next to it that shows their sales in the last 30 days so my sales team can see if their account is declining or growing.
Thank you !
Bobby
------------------------------
Bobby Hollis
------------------------------