+ Reply to Thread
Results 1 to 8 of 8

Require a formula to see if 2 dates fall within Year end and Start

  1. #1
    Forum Contributor
    Join Date
    04-02-2010
    Location
    penrith
    MS-Off Ver
    Excel 2007
    Posts
    522

    Require a formula to see if 2 dates fall within Year end and Start

    Hi I need a formula that will look at a start date and an end date and display the first available set of dates that fall within that period, it also needs to be flexible if the uset changes the start and end dates.

    Please see the attached sheet for details.

    Cheers

    J
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Require a formula to see if 2 dates fall within Year end and Start

    Hi John,

    You have what you need in column M


    so if(AND(start<c1,end>c2),EXAMPLE1,if(and(start<c1,end<c2),EXAMPLE2,if(and(start>c1,end<c2),EXAMPLE3,IF(AND(start>c1,end>c2),EXAMPLE4,"ERROR"))))

    Something like that.
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Require a formula to see if 2 dates fall within Year end and Start

    Let's try this.

    1)
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    2)
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  4. #4
    Forum Contributor
    Join Date
    04-02-2010
    Location
    penrith
    MS-Off Ver
    Excel 2007
    Posts
    522

    Re: Require a formula to see if 2 dates fall within Year end and Start

    The problem I encounter is if the start or end date are equal with the Fy start or end date it can calculate them.

    JD

  5. #5
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Require a formula to see if 2 dates fall within Year end and Start

    change the > to >=

  6. #6
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Require a formula to see if 2 dates fall within Year end and Start

    Is this a comment for my suggestion?

  7. #7
    Forum Contributor
    Join Date
    04-02-2010
    Location
    penrith
    MS-Off Ver
    Excel 2007
    Posts
    522

    Re: Require a formula to see if 2 dates fall within Year end and Start

    Cheers Guys, gonna go with Fotis's answer for simplicty, thanks for the quick replies.

    JD

  8. #8
    Forum Contributor
    Join Date
    04-02-2010
    Location
    penrith
    MS-Off Ver
    Excel 2007
    Posts
    522

    Re: Require a formula to see if 2 dates fall within Year end and Start

    The forum froze when I tried to post a reply.

+ 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] Require a formula to indicate how many days fall within a series of months
    By john dalton in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 05-23-2014, 06:39 AM
  2. Replies: 7
    Last Post: 03-26-2013, 08:32 AM
  3. Replies: 3
    Last Post: 08-14-2012, 05:14 AM
  4. Replies: 4
    Last Post: 01-20-2010, 10:10 AM
  5. Replies: 2
    Last Post: 07-12-2009, 04:52 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