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.