Results 1 to 6 of 6

Working Dates and Off Dates Formula

Threaded View

  1. 08-25-2011, 07:24 AM #1
    jettechfsr
    jettechfsr is offline
    Registered User
    Join Date
    08-25-2011
    Location
    Macau
    MS-Off Ver
    MAC Excel 2008
    Posts
    18

    Working Dates and Off Dates Formula

    See attached workbook sheet 5 Can someone help me with a formula for column C that will display "Worked" "Off" or Blank ""

    Dates are B7:B371 to check if they are Between D7:D371 & E7:E371 = Worked or F7:F371 & G7&G371 = Off and if date is not with either ""

    Has to be a formula this is being done on MAC Excel 2008 so no macros
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1