+ Reply to Thread
Results 1 to 11 of 11

Dates list of ZERO sales

  1. #1
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Dates list of ZERO sales

    This is raw date from 1/10/2014 to 16/12/2014

    I am trying to find the list of dates of nil sales

    I have a way to do it but its long , a sales frequency graph

    The expected result should look as follows , see below and so on since the first sell of this salesman was on 6/10/2014
    If the formula can exclude sunday dates I will be appreciate that , without sunday exclude will do too

    1/10/2014
    2/10/2014
    3/10/2014
    4/10/2014
    5/10/2014
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-20-2014
    Location
    israel
    MS-Off Ver
    2007
    Posts
    21

    Re: Dates list of ZERO sales

    Hi,
    Attached a workbook with an array formula which supplies the required,
    It also excludes sundays.
    01 02 2014 no sale dates solution.xls

    Regards,
    Eran.

  3. #3
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: Dates list of ZERO sales

    Yes griruy , exactly as needed , not sure if I have to start a new thread of this ,
    Will close the thread but was looking for the idle no sales week monday to saturday
    to cross check if person was at leave or was just warming the chair with nil sales

  4. #4
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: Dates list of ZERO sales

    Maybe a conditional formatting trick that will detect this ?

  5. #5
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: Dates list of ZERO sales

    If the conditional trick exists it should highlight say 1 2 3 4 and not 7 and 10 and 11 and 15 16 17 18

    01-10-14
    02-10-14
    03-10-14
    04-10-14
    07-10-14
    10-10-14
    11-10-14
    15-10-14
    16-10-14
    17-10-14
    18-10-14

    Refer to thread : counting dates that are consecutive
    Last edited by makinmomb; 01-02-2015 at 04:38 AM.

  6. #6
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Cool Re: Dates list of ZERO sales

    Here is the conditional formatting trick I have used.
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    both formulae are separate rules and applied on Column I
    Check the attached file:-
    Attached Files Attached Files
    Regards,
    Vikas Gautam
    Excel-buzz.blogspot.com

    Excel is not a matter of Experience, its a matter of Application.

    Say Thanks, Click * Add Reputation

  7. #7
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: Dates list of ZERO sales

    Vikas sounds interesting I don't see shades , maybe you attached before shading

  8. #8
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Dates list of ZERO sales

    Here is my way for achieving the desired result
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    with conditional formatting applied as in Post #6
    Attached Files Attached Files

  9. #9
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Dates list of ZERO sales

    Oh.!
    Sorry
    Actually I ignored compatibility warning that why its not showing up.
    However, I have corrected it in Post #8.
    and a courteous request for you as well.
    If you have higher version of excel then you should upload .xlsx files form here on.

  10. #10
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: Dates list of ZERO sales

    Yes this is beautiful indeed
    Wish you powerful 2015 year of excelling

  11. #11
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Dates list of ZERO sales

    Thanks for the Feed Back...
    and Same to you for wishes..

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Would like to update stock list from daily sales list
    By DIPPYDOR in forum Excel General
    Replies: 6
    Last Post: 05-29-2014, 10:53 AM
  2. How to calculate monthly sales between two dates!
    By rojashan in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-21-2014, 09:32 AM
  3. Replies: 6
    Last Post: 10-19-2013, 04:53 PM
  4. Replies: 8
    Last Post: 02-14-2013, 03:45 PM
  5. Replies: 9
    Last Post: 09-01-2012, 07:25 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1