1

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:

https://docs.google.com/spreadsheets/d/18wUcq_zBV4MdcXTUShYl7N2cx_TBVq9EONSIGvVlsuk/edit#gid=836202959

2

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

=(A2+B2)/2

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

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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