This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am trying to calculate the difference between two dates, with the answer displayed in months, and was referred to the =DATEDIF formula by a friend as shown below:
But when I enter that formula for my data, the second cell keeps turning red and when I finish the formula and press enter, a pop up box appears and tells me my formula is broken (please see screenshots below)
My formula input
The pop up message I receive
Can someone please help? I'm a little lost....
Thank you so much
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Hello Stephanie,
If you are getting the "There's a problem with this formula." error, it is likely that you are using a broken formula. For tips on how you can avoid broken formulas, we recommend that you check on the link below:
If you have other concerns, feel free to reach out.
Your formula works fine for me. Can you upload a copy of the workbook for us to take a look at?
Regarding the cell colors, these correspond to the cells in the formula, so K2 is blue, and L2 is red. It's Excel's way of helping you "see" what your formula is referencing.