Forum Discussion
Formula assistance 50% between two dates
Hello Excel Subject Matter Experts!
I need assistance creating a formula to find the halfway point between two dates.
Example
if CELL C2 contains: the start date: 3/1/2023 and CELL C3 contains the end date: 3/30/2023 the formula will return the date 3/15/2023 in CELL C4.
Thank you in advance for your assistance creating this formula.
You can find the halfway point between two dates in Excel by calculating the average of the two dates. Here is a formula to do that:
Assuming the start date is in cell C2 and the end date is in cell C3, you can use the following formula in cell C4 to calculate the halfway point:
=(C2 + C3) / 2
This formula adds the start date (C2) and the end date (C3) together and then divides the result by 2 to find the average, which gives you the halfway point between the two dates.
In your example, if C2 contains 3/1/2023 and C3 contains 3/30/2023, the formula in C4 would return 3/15/2023.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark them as helpful and like it!
This will help all forum participants.
2 Replies
You can find the halfway point between two dates in Excel by calculating the average of the two dates. Here is a formula to do that:
Assuming the start date is in cell C2 and the end date is in cell C3, you can use the following formula in cell C4 to calculate the halfway point:
=(C2 + C3) / 2
This formula adds the start date (C2) and the end date (C3) together and then divides the result by 2 to find the average, which gives you the halfway point between the two dates.
In your example, if C2 contains 3/1/2023 and C3 contains 3/30/2023, the formula in C4 would return 3/15/2023.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark them as helpful and like it!
This will help all forum participants.
- Thank you so much! I knew it was an easy formula - I was totally overthinking it. This is working perfectly!
