+ Reply to Thread
Results 1 to 4 of 4

Find difference between two dates and build a calendar

  1. #1
    Registered User
    Join Date
    05-22-2017
    Location
    Houston, Texas
    MS-Off Ver
    2013/2016
    Posts
    20

    Find difference between two dates and build a calendar

    I am trying to build something out formulaically which will find the difference between two dates (Start and End), and then distribute it out into a 12-month calendar.
    For example, with a Start date of 1/23/2019 and an End date of 4/1/2019, the difference is 68 days. I have 12 columns to the left each representing a month. Is there
    a way to build a formula that runs down 12 columns dispersing the count of 68 days throughout until the End date? So there would be 8 days in Jan-19, 28 days in Feb-19,
    31 days in March-19 and then 1 day in April-19.
    Last edited by dominicb; 08-22-2019 at 12:01 PM.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,535

    Re: Find difference between two dates and build a calendar

    It would be easier to help if a manually produced sample was provided, however attached is my interpretation of what you want.
    The 12 columns are filled with the dates of the 12 months for 2019
    Start and End dates are in N2:N3
    The following conditional formatting rule is applied to the dates in the 12 columns: =AND(A1>=$N$2,A1<=$N$3,A1<>"")
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Find difference between two dates and build a calendar

    This thread appears to be a duplicate of this one.

    Or am I missing something?
    Dave

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,535

    Re: Find difference between two dates and build a calendar

    One day I will learn to check and see if the OP has started another (duplicate) thread before I invest time.
    I hope that you have a blessed day.

+ 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. How to subtract two dates & times to find the difference?
    By teamtargaryen in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-24-2019, 12:04 AM
  2. [SOLVED] How to find the difference between two dates, and display it as (**y ***d)
    By PistachioPedro in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 11-01-2013, 01:46 PM
  3. How to find the difference between 2 dates in days
    By nav505 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-11-2013, 07:45 AM
  4. To find difference between dates
    By Bhawna in forum Excel General
    Replies: 2
    Last Post: 08-08-2012, 10:07 AM
  5. Find the difference between dates
    By SMB618 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-05-2010, 01:43 PM
  6. how do i put formula to find difference between two dates
    By A.D in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 05-12-2005, 01:06 PM
  7. [SOLVED] Is there a way I can find the time difference between two dates a.
    By OutbackPower in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-17-2005, 02:06 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