Results 1 to 5 of 5

Labeling dates based on the work week it falls under

Threaded View

  1. #1
    Registered User
    Join Date
    04-21-2015
    Location
    NJ
    MS-Off Ver
    Excel 2013
    Posts
    9

    Labeling dates based on the work week it falls under

    Hey, first post! Happy to be a part of this forum.

    I have, what should be, a relatively easy question.

    So I have a column of dates, let's say column A, that consist of dates that only fall in the work week (Mon-Fri). In column B, I want to say if the date in column A is either hold (1/1/2001), late (any date before today), week (today and any date in the current work week), week +1 (any date in the following work week), week +2 (any date in 2 work weeks from today), week +3, week +4, and future (any date more than 4 work weeks from today).

    For example: Let's say today is 4/23 (Thursday)
    Col A - Col B
    1/1/2001 - Hold
    4/22/2015 - Late
    4/23/2015 - Week
    4/24/2015 - Week
    4/27/2015 - Week +1
    5/6/2015 - Week +2
    5/15/2015 - Week +3
    5/18/2015 - Week +4
    5/25/2015 - Future

    So far I've only been able to figure out how to label Hold. =IF(A2=DATE(2001,1,1),"Hold",""). Can someone help me out with this?

    Thank you!!
    Last edited by imsteve123; 04-27-2015 at 07:17 AM. Reason: Solved

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 05-16-2014, 11:30 AM
  2. [SOLVED] Check if a Certain day of the week falls between two dates
    By cwang213 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-10-2013, 09:22 AM
  3. [SOLVED] Pull information based on week date falls under
    By mjhopler in forum Excel General
    Replies: 1
    Last Post: 06-19-2012, 11:54 AM
  4. Replies: 5
    Last Post: 06-24-2010, 06:21 AM
  5. use dates to get week it falls on
    By Khaos176 in forum Excel General
    Replies: 6
    Last Post: 12-12-2008, 03:36 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