I have two date columns in mm-yy format and I need to know the halfway date of these two. What formula do I use? I tried simple subtraction of the two dates and then divided it by two but it didn't yield the right result.

enter image description here

Here's the link to the spreadsheet:


1 Answer 1


To find the number that's halfway between A2 and B2, use the formula


(You'll need to apply a suitable date format to the output.)

  • That was easy, but i missed it.Thanks Live Forever! :)
    – Vee
    Commented Feb 5, 2016 at 6:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.