How to find the mid point of a mid point between 2 dates

I have start and end date for an event. I would like to find what the mid point time period between these dates is.

Is there a formula I can use to do that?

Accepted answers

You can create a number formatted line item for mid point between the dates ( i.e. (End date - Start date)/2) and add this to the start date to get mid date.

Please find the snapshots below

Hope this helps.

Thanks

All comments

Jitendra.Vishnolia

Hi @RoopaliB ,

You can create a number formatted line item for mid point between the dates ( i.e. (End date - Start date)/2) and add this to the start date to get mid date.

Please find the snapshots below

Hope this helps.

Thanks

RoopaliB

Hi @Jitendra.Vishnolia

This works. Thanks!

Quick Links

Can you help?

Unanswered questions

How do I determine why Anaplan API login fails intermittently ?
Hello, My interface uses basic authentication to log in to Anaplan. The login process has been failing intermittently for about a week. How can I identify the root cause of these Anaplan API login failures? Username and password are correct. The account is not locked or expired. Thanks, Jorge Palma
Anaplan XL license issue
Hello , I recently started Anaplan XL course , added XL however not able to add license How to ad license
Error while uploading ADO screenshots
Hello Anaplan Community, I'm facing an issue while uploading ADO screenshots, crosschecked my file size and naming conventions they are correct as mentioned in the lesson. Anyone faced the same issue? Pls let me know how if any solution to this problem. Thank you.