# Does cell A1 fall between X & Y dates and Splitting year into 13 periods of four weeks

1. ## Does cell A1 fall between X & Y dates and Splitting year into 13 periods of four weeks

Hi I've included a workbook which hopefully will explain this better but here goes:
I need to check a date in a cell to see if it falls in a certain period of the year.
The year is split into 13 periods of 4 weeks each starting on 15/03/15 this year.
So for example today (28/03/15) is Period 2

Please if anyone can help I'd really appreciate it.

Thanks,

Kevin.

2. ## Re: Does cell A1 fall between X & Y dates and Splitting year into 13 periods of four weeks

will you provide the result manually for 1 or 2 instances

3. ## Re: Does cell A1 fall between X & Y dates and Splitting year into 13 periods of four weeks

Does attachment work?

4. ## Re: Does cell A1 fall between X & Y dates and Splitting year into 13 periods of four weeks

See attachment...

5. ## Re: Does cell A1 fall between X & Y dates and Splitting year into 13 periods of four weeks

Consider applying conditional formatting to Period due column to indicate due this period and next.

6. ## Re: Does cell A1 fall between X & Y dates and Splitting year into 13 periods of four weeks

C2=IF(B2<TODAY(),"","P "&INT((B2-1-DATE(YEAR(B2)-(MONTH(B2)<3),3,15)+1)/28)+1&" of "&YEAR(B2)-(MONTH(B2)<3))

D2=IF(INT((B2-1-DATE(YEAR(B2)-(MONTH(B2)<3),3,15)+1)/28)=INT((TODAY()-1-DATE(YEAR(B2)-(MONTH(B2)<3),3,15)+1)/28),"Yes","No")

E2=IF(INT((B2-1-DATE(YEAR(B2)-(MONTH(B2)<3),3,15)+1)/28)=INT((TODAY()-1-DATE(YEAR(B2)-(MONTH(B2)<3),3,15)+1)/28+1),"Yes","No")
TRY THIS

7. ## Re: Does cell A1 fall between X & Y dates and Splitting year into 13 periods of four weeks

Thanks everyone "nflsales" was the one that worked best as I couldn't load the other examples back saying they were corrupted?

I appreciate all the help

Kevin.

9. ## Re: Does cell A1 fall between X & Y dates and Splitting year into 13 periods of four weeks

No, Thank you! My head was exploding!

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