**Question description:**

*This user has given permission to use the problem statement for this blog.*

Need to calculate out two equally spaced points between a range of dates. Basically like the MEDIAN function between two cells that have dates, but I need to produce two equally spaced points between that range. For example. If I have the following date range (A1) 2/2/2018 (B1) 7/2/2018, then that's roughly 150 days total. I want 4 equally spaced points (Start, Start-Mid, Mid-End, End). So I'd say that's 50 day chunks spaced euqally. Which would produce 4 total dates 2/2/2018 - 3/24/2018 - 5/13/2018 - 7/2/2018.

Solved by K. J. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
20/04/2018 - 05:22

Hi

User
20/04/2018 - 05:23

Hello

Excelchat Expert
20/04/2018 - 05:23

Welcome to Got it Pro

User
20/04/2018 - 05:23

Thanks

Excelchat Expert
20/04/2018 - 05:23

I understand your problem let me try to come up with the solution

User
20/04/2018 - 05:23

Hopefully my explanation made sense

User
20/04/2018 - 05:23

Thank you

Excelchat Expert
20/04/2018 - 05:23

Just give me 2 Minutes

User
20/04/2018 - 05:23

Sure, no problem

Excelchat Expert
20/04/2018 - 05:25

Is it fine?

User
20/04/2018 - 05:26

Yes, I think this works for me. One second. Let me plug it in and see

Excelchat Expert
20/04/2018 - 05:26

sure...

Excelchat Expert
20/04/2018 - 05:27

?

User
20/04/2018 - 05:27

Yes, this formula works. Thank you!

User
20/04/2018 - 05:27

Have another question if that's okay?

Excelchat Expert
20/04/2018 - 05:27

your welcome :)

Excelchat Expert
20/04/2018 - 05:27

ok tell me

Excelchat Expert
20/04/2018 - 05:28

Actually I need to answer one question anyway we have a time. Please tell me

User
20/04/2018 - 05:28

Is there a way to chart these out like a gantt chart, showing the 4 plotted points?

Excelchat Expert
20/04/2018 - 05:28

Let me check...

User
20/04/2018 - 05:29

Thanks!

Excelchat Expert
20/04/2018 - 05:32

Just give me 2 minutes

User
20/04/2018 - 05:32

Sure, no problem

Excelchat Expert
20/04/2018 - 05:38

Just check this

[Uploaded an Excel file]

User
20/04/2018 - 05:38

o

Excelchat Expert
20/04/2018 - 05:38

Just extend time let me share one more file as well

User
20/04/2018 - 05:38

Okay, thank you!

Excelchat Expert
20/04/2018 - 05:39

Extend time

Excelchat Expert
20/04/2018 - 05:41

This is another sample

[Uploaded an Excel file]

User
20/04/2018 - 05:42

Great!

User
20/04/2018 - 05:42

Thanks a lot!

Excelchat Expert
20/04/2018 - 05:42

Thank you..your welcome..:)

Excelchat Expert
20/04/2018 - 05:42

Please provide your valuable feedback and remarks...

User
20/04/2018 - 05:42

I will do so!

User
20/04/2018 - 05:42

Have a nice day!

Excelchat Expert
20/04/2018 - 05:42

Request you to end the session to support other users.

Excelchat Expert
20/04/2018 - 05:42

Have a nice day !

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*