Mid Date between 2 dates


Can anyone help me with a formula to find the mid date between 2 dates. Like what will be the mid date between 1st Jan 2021 and 31st March 2021.


Best Answer


  • Thank you for the help!! It's working.

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 12/02/20

    Welcome @Preeti Kumar

    PMP Certified

    [email protected]


    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • Hello! I used this function and it is working great for most of my needs. However, I'm wondering if there is a way to combine this with the WORKDAY to only return a workday as the result? I am setting up reminders to contact the project teams about the budget on the midpoint between the start and finish of a project --- but sometimes this exact midpoint lands on a Saturday. Is there a way to return the closest business day (M-F)?


  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @EJ

    Yes! WORKDAY is the exact function to use in this situation.

    Instead of:

     =[Start Date]@row + ([email protected] / 2)


    =WORKDAY([Start Date]@row, ROUND([email protected] / 2))



  • @Genevieve P. Thank you so much! That worked perfectly.