+ Reply to Thread
Results 1 to 3 of 3

Populate a daily calendar using the dates between Date of Arrival and Date of Departure

  1. #1
    Forum Contributor
    Join Date
    05-09-2013
    Location
    Mauritius
    MS-Off Ver
    Excel 2010
    Posts
    116

    Populate a daily calendar using the dates between Date of Arrival and Date of Departure

    Hi all,

    I'm using Excel 2010. I need to populate a daily calendar with the number of nights spent, extracted from the Date of Arrival and Date of Departure of individuals. I posted something similar recently on this forum (http://www.excelforum.com/excel-form...20#post3255820) and I got some excellent solutions to that problem.
    Now I need a solution to do nearly the same thing but on a daily basis rather than a monthly one. I've played with the formula provided by duanzhuanming in the post I mentioned above by replacing the "MONTH" with "DAY" and "EOMONTH" with "EODATE" but it's not working!

    I've attached a small sample file so that you get an idea of the problem. I've manually filled the second row to illustrate what I want to do.

    dates.xlsx

    rgds,
    zicitron

  2. #2
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Populate a daily calendar using the dates between Date of Arrival and Date of Departur

    In C2

    =IF(AND($A2<=C$1,$B2>C$1),1,"")

    Also format columns A & B as mm/dd/yyyy
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Forum Contributor
    Join Date
    05-09-2013
    Location
    Mauritius
    MS-Off Ver
    Excel 2010
    Posts
    116

    Re: Populate a daily calendar using the dates between Date of Arrival and Date of Departur

    Thanks Ace_XL!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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