Page 5 of 5 FirstFirst ... 3 4 5
Results 41 to 45 of 45

Thread: Do I use a COUNTIF or a IFERROR(INDEX(MATCH formula??

  1. #41
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,509
    Articles
    0
    Excel Version
    Excel 2016


    Register for a FREE account, and/
    or Log in to avoid these ads!

    I don't see any in your sample that go over 1 day anyway. And if there are some, we may have problems with all that we did previously to chart the data.


  2. #42
    Bummer...Then for now nm. Yea, the sample was just that. But I thought it might be nice for them to enter a single event (start and end date) verses entering a new one for each day. It is alight! I thought it might be a "simple" add.

  3. #43
    Upon entering the first month here of September, I need to add a minimum of 3 rows daily to the weekly calendar. Upon doing so, the Day of the week change and are not in sequential order. Formulas are good and match previous versions, but why is this happening?

    (Ex) add 3 rows to Monday and the following day "Tuesday" now becomes "Wednesday" without any formula change.

  4. #44
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,509
    Articles
    0
    Excel Version
    Excel 2016
    It's because of the formula used to determine the date.... it is dependent on row numbers between.


  5. #45
    Wow! So sorry! It sure does!

    ~Thanks again

Page 5 of 5 FirstFirst ... 3 4 5

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •