Results 1 to 6 of 6

WEEKDAY formula confusion

Threaded View

  1. #1
    Registered User
    Join Date
    01-21-2011
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    7

    WEEKDAY formula confusion

    ----M-----------------------------N------------------------------O------------------------------------P
    1--Cal Start Date-----------Cal End Date--------------"1 = Sun,2 = Mon…"--------No of specific days
    2--27/07/2010----------------15/11/2010----------------2-------------------------------------16


    I had this spreadsheet sent to me. In the specific days column is the array formula

    {=SUM(--(WEEKDAY(M2-1+ROW(INDIRECT("1:"&TRUNC(N2-M2)+1)))=O2))}

    Can someone break this down and explain it to me, because I am LOST!

    Many thanks,

    Tom
    Last edited by tomdenners; 06-24-2011 at 07:55 AM.

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1