Results 1 to 42 of 42

formula to write the dates of rest days for every employee in one cell

Threaded View

  1. 01-10-2018, 06:21 AM #1
    leprince2007
    leprince2007 is offline
    Forum Contributor
    Join Date
    02-24-2015
    Location
    Egypt
    MS-Off Ver
    Office 365 ProPlus
    Posts
    769

    formula to write the dates of rest days for every employee in one cell

    Hello Everybody,
    Question: I want a formula to write the dates of rest days for every employee
    Note 1 "R" refers to rest days
    Note 2 "Row B" contains dates
    Note 3 The result are like this "01+07+13+19+20+26"
    Office:2007
    Limitations:Formula Only-No helper columns-No vba-No powerquery
    I hope you help me
    Attached Files Attached Files
    Last edited by leprince2007; 01-11-2018 at 07:23 AM.
    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)

Similar Threads

  1. Formula that counts dates that are between 60 days and 30 days before todays date
    By dandavis1 in forum Excel General
    Replies: 10
    Last Post: 02-19-2019, 03:28 AM
  2. Write rest days for all year
    By leprince2007 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-23-2017, 03:33 PM
  3. Calculating the number of days between dates & lleaving the formula containing cell blank
    By IntrntDetective in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-29-2014, 05:34 PM
  4. Rest of the days
    By Rashidul in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-25-2013, 10:00 PM
  5. Employee Time Tracking - Sick days & Consecutive Days
    By notaguru6 in forum Excel General
    Replies: 6
    Last Post: 08-09-2013, 12:50 PM
  6. Excel 2007 : How do I write a formula that excludes non-working days from the result?
    By SamanthaJane in forum Excel General
    Replies: 2
    Last Post: 05-02-2012, 06:22 AM
  7. Macro : To find word and Select rest after this cell and delete rest
    By Zortabello in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2010, 08:06 AM

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