Results 1 to 9 of 9

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

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-14-2012
    Location
    England
    MS-Off Ver
    Excel 2010/2013
    Posts
    100

    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.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pull dates from multiple columns that fall into the same month/year.
    By safrau in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-23-2014, 12:15 PM
  2. [SOLVED] Require a formula to see if 2 dates fall within Year end and Start
    By john dalton in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-06-2014, 09:12 AM
  3. Splitting Semester and Year into 2 columns (Fall '10)
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-17-2012, 03:08 PM
  4. Replies: 4
    Last Post: 01-20-2010, 10:10 AM
  5. Replies: 2
    Last Post: 07-12-2009, 04:52 PM

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