+ Reply to Thread
Results 1 to 5 of 5

Divide dates equally in a time period

  1. #1
    Registered User
    Join Date
    09-01-2012
    Location
    Staffordshire, England
    MS-Off Ver
    O365
    Posts
    129

    Divide dates equally in a time period

    Please see attached example. The data i have is 3 cells: Start date, End date, and No of periods. I want the result to be equal dates spread through the given period.
    Date formula.xlsx

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,454

    Re: Divide dates equally in a time period

    Hello,

    In your example, you have the 1st of the month as the "equal" date. These are one calendar month apart. Is this the result you want every time, or would you rather it split to the nearest day etc...?
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Registered User
    Join Date
    09-01-2012
    Location
    Staffordshire, England
    MS-Off Ver
    O365
    Posts
    129

    Re: Divide dates equally in a time period

    Quote Originally Posted by sweep View Post
    Hello,

    In your example, you have the 1st of the month as the "equal" date. These are one calendar month apart. Is this the result you want every time, or would you rather it split to the nearest day etc...?
    Yes, I always want the first of the month showing.

  4. #4
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,941

    Re: Divide dates equally in a time period

    see the attached file
    Attached Files Attached Files
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  5. #5
    Registered User
    Join Date
    09-01-2012
    Location
    Staffordshire, England
    MS-Off Ver
    O365
    Posts
    129

    Re: Divide dates equally in a time period

    Quote Originally Posted by nflsales View Post
    see the attached file
    Thank you, nflsales. What is the difference and significance between the two different formulas in the yellow and blue columns please?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro to divide a range and insert them in new rows equally
    By Netaji in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2014, 09:51 AM
  2. [SOLVED] Divide Time Period across different Time Frames (Calculating Interest)
    By kopapa in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-21-2013, 03:09 PM
  3. Divide cell amounts between cells equally
    By hotwoz in forum Excel General
    Replies: 6
    Last Post: 07-08-2011, 05:54 AM
  4. Counting dates within a period of time
    By Justinmih in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-06-2008, 07:15 PM
  5. Counting dates within a period of time
    By rjchudek in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-04-2007, 05:09 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1