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

1. ## 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

2. ## 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.

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

Let's try this.

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

2)
Formula:
`Please Login or Register  to view this content.`

4. ## 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. ## Re: Require a formula to see if 2 dates fall within Year end and Start

change the > to >=

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

Is this a comment for my suggestion?

7. ## 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. ## 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.

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

#### 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