Mid Date between 2 dates

Preeti Kumar

Hello,

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.

Bassam Khalil

Hi @Preeti Kumar 

Hope you are fine, the following sample explain the formula you need.

1- Fin date, start date, mid date are Date type columns.

2- Duration is text/number type column

3- calculate Duration using this formula =[Fin Date]@row - [Start Date]@row

4- calculate mid date using this formula =[Start Date]@row + ([email protected] / 2)

5- you can convert the Duration & mid date to column formula to.

following screen shot show the sample:

Bassam Khalil

Hi @Preeti Kumar 

Hope you are fine, the following sample explain the formula you need.

1- Fin date, start date, mid date are Date type columns.

2- Duration is text/number type column

3- calculate Duration using this formula =[Fin Date]@row - [Start Date]@row

4- calculate mid date using this formula =[Start Date]@row + ([email protected] / 2)

5- you can convert the Duration & mid date to column formula to.

following screen shot show the sample:

Preeti Kumar

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

Bassam Khalil

Welcome @Preeti Kumar

EJ

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

Thanks!

Genevieve P.

https://community.smartsheet.com/discussion/comment/329776#Comment_329776

Hi @EJ

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

Instead of:

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

Try:

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

Cheers,

Genevieve

EJ

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