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

Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
Importing from Data Hub: Incorrect or Missing Mappings in Target Model
When importing data from a Data Hub to another model, I'm seeing values in the target model that don't exist in the source. For example, seller assignments are being tagged with subregions that aren't present in the source data - some assignments are missing expected tags, while others are mapped to seemingly random…
Postman/Anaplan - message "404, Not found"
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…