Calculating the number of months between 2 dates over multiple years

Options

Is there a way of calculating the number of months that have passed from one date to another over multiple years, in Excel I would have used DATEDIF but this is not available in Smartsheet.

Example of what I need

data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAARwAAACQCAYAAADa8dT3AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAABpUSURBVHhe7Z17qBbVu8dndyrJ0z0srMhM+1GYXbCsKJM0TDxRdugXWf9olKCBdJH8wwop+sOwC0J5uqBGmBJyMuiEiiVmqVlStBPipJWxLajTdXeyjuQ++7Oc53Xt2TPzzntb7/u6vx8Y5rJm1sysd63vPOv2vB1dXV09kSjx888/RyeddFK8J9JQGmWjtEnniCOOiH777bfoiHhfCCEaxoEDB6L9+/dLcIQQ4ZDgCCGCIcERQgRDgiOECIYERwgRDAmOECIYEpwaWLNmTTRr1qzop59+io8IIfKQ4NTAu+++Gx1zzDHR9u3b4yNCiDw00jhB0ZGiH374YbRy5cpo0qRJ0ebNm6PHH3/cHf/666+jBQsWRE899VR08sknu2Pz58+Pxo0bF02ePNmJFJYRVtG5554b3XTTTdEFF1zg4uP44MGDoy+++CJavnx59Nlnn7l77N2718U1derU6JprrnFxcv2SJUvcuYSdfvrp0V9//eXuBatWrYo2bdoU7du3Lxo7dmx02223lZ6nVjSaNhulTTakjSycKkEgRo8e7QozgoDQwNlnnx2dccYZJauH44RzHttLly6Npk2b5gQFkXjjjTfcecB5o0aNiu655x4nKM8++6wTKs5FaBAfA7EZNGiQE7Y5c+a4H9NYu3atu/+8efNcOGHr16+PQ4VoHhKcKkAMKNCXXXaZsxqwUDZu3BiHRk4ksE7gk08+ceGct23bNic8XAdYN1go1gaExYMVY+F33nmns4qA41grFi/XEUa8iBziZ+zYscNZXhwnnOfp7OyMQ4VoHhKcKqBaZEIDrP12HEQFYUBIdu7c6fZh9+7d7rzp06e75f777y8dT0L8P/74ozvHzgdExwTK7p8EMaJKZddhVWE9CdFsJDhVgOBQ6K1AU7gRAqoyYGLEeV1dXaV2F6pQ48ePd1UkfzGLxgfBorpl1S8Wg/jBrJ0kVOmwjvx7+NcL0SwkOBVilgsNw35hxoqhKmMgOOvWretT1TFLiPYfYP3cc8+57SQIGAwZMsStaVD2IS4EjmehbcivMnFP7m3tSpyHKArRbCQ4FYLVgrjQPuIzZcoUV5WxQm5tL361B0sGi4XGXywj1n64D+dyH4SNsT5+ozBgwdArRZVr8eLFfXpG6JFCdBYuXOjugxBm3UeIkKhbPEG7dGti2VjVCpYtW+bafObOnRsfaRztkkbNQGmTDWkjC6dNoX3HqllU86iqyYoRrY4Ep0259tpro127drkqE+N1aIy2apwQrYqqVAlkEpdHaZSN0iYbVamEEEGR4AghgiHBqYFWdk/BGB/ad4RoJSQ4NcCYHLmnEKI4ajROULTRDwsizT0FsM1MbuIy1xIM+GPGNoMDESkmblqvEsJlLis413dDgZXC7HGb/kDcI0aMcIP7bErFt99+6+LlWgYE0k1u0yzAv74eqGE0G6VNNmo0roEs9xQGiXv33Xc79xDMoaLrGnFiGsT1119fcheRdFnBOQhZMr4ssK4QL67lPggNYoTIAMfrKTZC1IIEpwqwRCjoFGSsCgbc+e4pADEy9xBnnnmmcz1hBZ/Jldbug8sKrrcwrB4sGI4XgfE3NuCP+zDdQYhWRYJTBVSBTGiAdbXtOLimQCh8kvtCHC5IcKoAwcFCoX2FJemeohKwZpK9XL5/HNp7hDhckOBUSFH3FEW54oornHVkLisQLRqAOQ4Ikvm9YY1/nSKYUCXFTIhmIsGpkKLuKYpCPPQsmcsKGpPZt/hp08HXDWFM2ESAikA1j3Yj3FeYmAnRbNQtnkDdmuVRGmWjtMlG3eJCiKBIcIQQwZDgCCGCIcERQgRDgiOECEbLCg6TFOkKbkcYS4PbinZ9/naCYQg2Tkm0PrmCYz5VWJL/a8QPnRVWDRbX4QDjZZigyYBAH9LJ3jO52GxzttPGzfjHOdfSnDXilhz/w3GL035HH8YTcV0jx+jwDPbPoaztmSvFf5ck/JVyNSO8RXMobOEk5woVnVw4EGGaAxM0kzCL20YmM6CPgXm2P3/+/PisyuF+K1asiPfKg0XAQEMGGDZqJjl/W8OAxTlz5rj3YzY8eaha0ckCVx4h/hpH1IdCgsNERYbI+6YrmSdtng8ZzaoTfJXsGjIax/inSQvnXPC/vv42cA7HuMa+ZDwL8XCcxb9PCLgX97TnskLkWxK4o6h34coCceM/qZL/zpkGlhDPhkuLRrqt2LRpk7PybMQ098L1hj/VAivLt4DYrxTf+knGQd6xfzb1f7Nq7yVqp5Dg4GoBcbEfiR+PjMNxH35gMhrD73GbwLwfMrefyfAdQxjxcS5xme8W8LeBgsT5fMWpqgBrBI+vG1YDUwrwKRMK7sU78uXmeXkP0oZCxTHgOM8WgsGDBzsLAsHJE15+hxdffLGP869GYNU0cyJmcM/Zs2e7bYSvFj9AaZAf/ffHwrIZ/f5vRr7hXn6+FGEoJDh4lOPHtP+vJkMhGPZjGogA1hAm7owZM9ycI4TCzwQmEogIEO5/aZNfXYuL6gfnkiFZw59//ulcOVC4ybgh4N25v4kJacCXHK9/9QKR5kvsL+Ug3UhTClIWS5YsibfCYtat/y61+gFKg//qsjxKnuN3QvRMAO034xj5NE+cRWMo3IZD5uAH5EuOsJjV40P4KaecEu8dmrGMYNWLH374wWUcBIgq1qJFi1whMxFqNGn+a9Laa2oBAeVL7C8+WRM4sVxIh6yqHOF4IcRCDFnY+L14B996bYQfIHN4Rh7l/fjgAffCmvFFD0u7nvlSFKOw4NhXwQp30hIBBIYqkGEigOvLekIGwgTHfScNn9wn78teTyjs/juC778mBDxDmujw+2DpIcRpbiz4aFAoOYcqRqOqFOQN8kJeOwnPn7x/PdKReyM2WDqWR8l/fBSSIm4WjwhHYcEBrBoKNxk7TXD4opCJsDpoz7GG5WTVKw2zhvg6l6vH02ZCtcPP0HZ9o7H3NiuCzM3zjBkzxu2HYMiQIW5Jg+ejapVnwfDxGDlyZEOrWFa9s+oM+YJt8g6U8wNULRdffLETG/Kp5TvW3N8a1clfNCbX0l7UKviN5u1ARYJDHRnMVE1CWwsZjS8VhdDaVyyT5YG5j2iQ8X7//ff4aDpYNTwDGYgvNffhWCi4F++IaY7w8c6NbIRNsnr16uitt96K9/pDWpZLc77uWGrWU1hviJ+2LUSHdKLb/48//nDd5FDOD1ASxMiqQ7aYWPlwPdaT36FBWpAPd+7c6a5buHChO5Z1r0ZiPWVpS1ZV+HBC/nASyJ9JeZRG2VSSNogP4lhL1Q6R4uNXyziuUMgfjhAtCE0FWeOTqBr644mSbXVYrDbOjWoj51N1ZN+vQnKtjWsLiQRHiBYCUcgbn0S7GxYUHSZUT7EaDKydXbt2OUEinG3EiqojjeZMAwHa9xCirKaRRiLBEaKFyBufhEjQloX/bGuD8tuquI5hD4SxICiIDhCfbSM4nMs5oZHgCNFC0B6TNT7Jhg1kNXbT/U+HAtUnFqpM9seI9N6ZZeOPwA5NTYJjL9YKYE7yLGk9F+0E5rD1VpBBDoeuW1GcvPFJhEFWnqAqxjQXqlNUx/yeU6tW0RvIoMdmVKcgV3AovCYqyWWggyhkNezVC75QVu+236Jd8PMKjZjWgFmEdnvXepI3PokqECPsGRJBWiI8NpUDsGYYWsJ5yTAYN26cG66C2DSjOgWFLBweDrX0l4EMPQH8mNawZ5MB6y06zCMj7nbFpmhgtcGTTz5ZWHQGKlgieeOTEG8aivnILV68uE8XPOOvyJdcxyTdZPc8QuMPiGwGueNwUFkGtqGqaf389hUiU5GR+OrzwrwU5hsFkpfjOEpNPKg1KsxgORt/QDjKa6OYKWSMhgWuI9GJnzAS3xLMZqdznDlcxE0mTxsFXZRy4yh4Dn7s5H3sOTFnLd1IF4O0smuoKpGhMG2T7+uPzbBtIH6DeLieHgwTf3PDYLOxG0mRsSb++xrkIfZNRG00Or87hYF3Jg2T78o1iDkDPUl/8hGFq5kFJ4siadMsSDt+g2ZN4iVtClk4jEhFFGwxc8+H4zapkwxFYaJO6cNIUysgZCriISOxzXWICXAdJiHhxItAcR0Zk4JMwpH5EBuEjcyaNneoEVh92i9IcN5557nnKgfn8A6YtwgSQoN45EFBpOAB13Bv0gvhMhD6ViyAPjwzo32B3zWtCzftXckLflcxjaPmqkQUhzTze7WaQSHBoZAgCrZYofPhy0pmYI3g8BVKFkCOk6HIOEA8iBCwRlgQHTLc8ccf7wQF7Dq+aogOwmYZl25AwrCYmomZvFkNej68owkv78Y7+eJRBAqi/Q72ATArqR1AHLO6cJPQJUy4iTz5AGu2iMCLg2Bxkr6UlWZSSHAQD8TElrSHpqAxaZMXYyFDZIGwAAWNgodYUOD48rNQkMiE1qXHMeLkqwi//PKLW0NWF2FoTGjKPQ/vhcVoDc4sQFpUAgWWdMQqIO2a/eWqlLwu3CTkBz4ydi5pZ8dFMSi3WJPkv2ZSSHCKQOYh4/P15uUQqSyscFFguIbCg1mNZUOCkPk4PmjQIHceAkeYLf6M4iIWRT2xNpVktfLzzz8v/ZgmqGnwXpi2Vj1gqRarVrVDdQp4zlGjRrntvC7cJIgTHyVLL1uS1VrR+lTVhmOWho99nfjq0BiYZuHQ7sK11mZB4cXMw4JJxnnsscc6MxpoSCReChfbVLcs49Iaz7VW/Wo0iAqZn3fheQDxQURoxAXf+gAE1DCxNfcSxFMEEzG/GuF7uGvl6hQfBWvUtufM68JNvivp6XcVs7b4RHvxL73m6YJ4ux94ROPHpZAgDP5C24MVFrbJOHv27HEZ5+ijj3aZpru7241wpEGXa4YNGxZ9/PHH7pobbrghmjhxomtsxVUoGWrLli3RUUcd5b7+F110kTufeLEeiPf777+PLrnkEvdl4zpavTlOAzXiRTgiRUNytfAsluGz4BnwPPjmm2868SSNhg8fXmr0hiOPPNJZfSx8yYFn5tm59uWXX47WrVvnetdIN3tuXJXyzhQyf/vUU0917Vbcj/NYTjzxxGjr1q3R+eef754pFEXSiLxBurD+4IMPotNOOy2aOXOmex9gzfvzPnyc6Nn5+++/nSAl35U04yNDWnKMjw/nkT9ajSJpM1AhbYK4p8AC4StPdajVzeBqujX5EjPGBB544IFSoQoB3Zw2/CAUrdz122yUNtkU7hYX+SAwNMiZpRcKqmxYnyHFRohakODUkZDWGwJH9cKvxgnR6sjjXwKZxOVRGmWjtMlGVSohRFAkOEKIYEhwWhDaZ9LGOgnR7khwqgRBsOkJrIsO4BNiICPBqQLEhgGHNo2DcTAMYrORxUKIdNRLlaBcLwOD/LBokoMYESFGwJrfoDRfL4zR4TxGXjOKm1HGnM8UCeYWETdz0Jg5zzwpriGM7m/zneP7wPGhGsZzM6KbeBibgyDauCDuaz6H/Oex6xBQ30dRHuqJyUZpk416qarAZignx9xQUPHGBhRuCj6F2ff1YhAHgwRxs4A4MJeMofpYSwgKxwzEhnuZJUXceRNWH3rooWjBggXuxzWfMYzyRvzmzZvnnocw5qQZiBniVOvf7ApRDglOHTFrAusiz9cLlgQCw3lYMMy9QYAAcUl67cca4jzCsKyYV5QG4dwPFxn8zS5WC+zYscMJGccJx/mXhQH35tpWcfUhDl8kOA2gEl8vVrXKAuECqlxU5bCOTNjyQMTMUmJyJJaRPQ9xYdUIERoJToVk+cOhQFv7TaW+XnD/kQaCwcxyvCgSF1Uq2mHMLUYetNWYMDHj2hq4/UWI0EhwKoRCbP5wrC0F8UEIqMZAnq+XJFSrEAfrVicuGpWB6xEvCzMfOllwLSLFPek1oyoHNECzb8+LxYVAChGaXH84A5FK/OGsWLHCVZ2o5uDbxwQHocjy9WLWic3w5l60nSAqnI/7VHzp4D+GcwgjrldeecX5lUHsJkyY4K71wXcOcRHHhg0bnI8cGqU5Rjz+8yKIPAt+Z7gOqw0rqCjy+ZKN0iabYP5w2ol27dakR4yGYRp/G426frNR2mRD2qhKJYQIhgRHCBEMVakSyCQuj9IoG6VNNqpSCSGCIsERQgRDgtNG0BOVHHAoRDshwakC84GThk0hqIcwIDAaoCcOJyQ4VcKI3jRRYcSxBn4JkY4Ep0rwW5MUHKYMIDb+bG+Eib+ltYmTbNukSq7HisF3DmG4tyAOYJ9RyuxzjsGkS6wrwjlucQnRDkhwqmTMmDHOx4zvm8bcQNhcKKBKhEMtJl+yIBjmpwYQlaFDh7rJlEyNsDD2ETUmftqkUECk8HlDXEz6lJdB0U5IcKoElxJMjty2bZvbR3gQGo4xGdNAlBAN5lex2Ixvw0QFmM/kX5uG/bsnC8/A/BQh2gUJTg0wbwlBgY0bN7pZ2QiBYVUum6gJ/rYQAw0JTg3YRElmeiM8U6ZMcfuGhfvVrrSGZiEGChKcGqHNBvcRNBSnueikioVLCBp3WRAn81NTjkGDBpWtYgnRTkhwasTEg0bkNHCujvc/epZYaKcp8s8IQNxYTn4vlRDtjCZvJtDku/IojbJR2mSjyZtCiKBIcIQQwZDgCCGCIcERQgRDgiOECIYERwgRjI7Ozk51iwshgtDR3d0twfFgGoL+1D8fpVE2SptsSBtVqYQQwZDgCCGCIcERQgRDgiOECIYERwgRDAmOECIYEhwhRDAkOEKIYEhwhBDBkOAIIYIhwRFCBEOCI4QIhgRHCBEMCY4QIhgdW7ZskXsKIUTDOeGEE+QPJ8mvv/7q/qxOZLN3716XeUR/yD9Km3RIG1WphBDBkOAIIYIhwRFCBEOCI4QIRjDBwYHycccdV1q2bt0ah4gsnnjiiaijo8MtI0eOjI8e5MsvvyyFsbz33ntxSH8I889Nnr9q1arS8dmzZ8dHa8P/rbO4+eabo9WrV8d7h7jvvvtKx5955plSPGz7kIf8+5DHfNi/8MIL472DWD5Mwj0tHrYbid0n7Tl477zwomnjQxokw/208eNhSZbNovcpQjDBufHGG6O77ror6u7ujpYtWxZNmjSpXwYRh0AQ5s2bF23evDnq6elxgjN58uQ4NIpGjBhRClu5cmU0bty4OKQ/XV1d7nzOteXqq6+OQ6No2rRppbiWLFmSK15FoFDYb806rQAjNhs2bIj3+vL2229Hl156qcsfDz/8cNTZ2ekWtv08Qx567LHH3H1Yjx49Og45yEcffRRNnDgx3jtYyJLnAIXopZdecvGwcF6tBSuLvLShoM+YMcO9q4WTTj5F08ZAnL766qt47xCWNoQvXbq09O7Jsln0PkUJIjg8IC996623uv1bbrnFrb/77ju3Fv3ZsmWLEwkThunTp0e7du1y2+CLxtixY906Syi++eabfhaSgXXj32fWrFnRq6++6rarhcJrvzVr9g2zSrKwzMxfraxZsya67rrr3DYL2xwD+wpPnTq1z9ovDO+//3501VVXuW0KNmJDHEkocAiW8eCDD7pjjSAvbV577TUnMvY3M08//XT0+uuvu20omjY+CNjw4cPjvUNY2lAWP/300/joobKJIEHR+xQliODYg5KgYCbh0KFD3Vr0hx9+9+7dJRFZvnx5pmhs377drX2rxYeMOmHChHivL0kx4reiulYtVijst7W1LwTr16/vU5B8fKtkz5497nkMtjkGV155pStIlvlt7Z9v1gAMGzbMfcHvuOMOt18OPpD+M9eDcmnD85pAplE0bQxEFoslDT9t0rCxaEXuUwnBqlSWwfi6Pfroo+7H919E9OWcc85xVgxVJdpWEIy1a9fGoYcgjCoR1aosKOAvvPBCajtNWqHyLSmfAz29cf33/ngvnSyr1Y4jFCxZ+FZJ2rP5x/gyb9q0yeUp1uQpw86zPHbvvfe6dRoUYqoKhn0Y6025tLGqj7WXJNufKkkbtlnMYvFJpo2PVSXtNyp3n0oJJjgkoH1lnn/+ebefbJwSh7CGXKwchIcfOc3CIYwF0aGROQ3imDlzpjuPbdppss7NYt/+nuifr/weTX7xt/hIYyj35TVID/IQFotZLuxbYUi23+RB1QULnOtZmol9jFmo6vptOEXTBrBuqBqmkZU2lEeElw9UowgiOFaFsq8M6ulXsUR/qELRnoKlA3Pnzu1TxUrCue+880681xeExjIf8fnnpn3lksL2w/8eiCb+R3f0n5/+1RtXfDCDrGpy1nEfxIJCZs+U9mx2jCoUVSr7grP2q1hYA9ZWUgQscCvoZkWk3b8WyqUNz//II4+4bUBErWG9krShvLGdZUmmpQ1iQ2MxYuNfl3efaghm4YjW5KyzzupThSJjm8gZD/7XvmjrnvyqlGGZ0aoJti6SSRGL8ePHx3sH213MYgG2OVYEGmPzqm55UCDTGlprpVzaIChZVJI2PD/vbxYbVTUsF+sRS6ZNlthALb9BGkEEx75CVj/kBVHuSr5AAw16paj6WAPuokWLSr1JNgbHrB3WnMs1SZLnsu+fSw+XbzkRdvvtt7tt44l/Oya6cthR8V55fOvVel6KQDvM5ZdfHu9Fbpt8QiZnYdvvlaIgmfXMmn2Ok794hqJQEK3qwn0okL6lUU/y0gaLhiqVwbaFV5I2VBHNWmNBPOmF43gybbg2S2wg7z5V0ftAPSGWzs5OjPHSsmzZstTzmr10dXX11kBag4ULF/ZJM5/Nmzf3CVu5cmUc0uO2e8Up3ss/F9i3sN7qVny0L3/834Gef3+5u6dj7v+4NEpLO3/x75cWzkKYnw/Szu0tKKV42PbDegtJKYyFfbsmea4t3I9zk8d7C2Upnqxriyy1po3/vr3CUDpe7ty8Z+bdLJy1f26voJXi8Bf/HLbTjle6kDZyT5FA7imyoZdqwxf7o1H/+r1cMGQg9xTZyD2FqIgjOqJo0j+KV62ESCLBEUIEQ4IjhAiGBEcIEQwJjhAiGBIcIUQwJDhCiGBIcIQQwehg9F+8LYQQDSSK/h8OW5ifC58dRQAAAABJRU5ErkJggg== There was an error displaying this embed.

in the months elapsed field is where I need the number of months formula so I can continue to monitor the number of cards raised since this initiative went live on 1st August 2019 (UK format date dd/mm/yy)

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!