Google-sheets – How to get the halfway date of two dates in Google Sheets

dategoogle sheets

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:

Best Answer

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.)