• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. M

    Finding the frequency of a day between two dates

    Hi, I would like to find the number of Sundays in between two dates. Is there a way? Thanks in advance for your help. Murugaraj
  2. M

    Using sheet names as variables

    We can use CELL function to retrieve various data about a cell and use them in formulas too. Is there a similar way to use sheet names? I have a workbook with productivity of each employee in a single table (a table with 20 employee names with their daily productivity). There is another...
  3. M

    Countifs criteria with dates and time

    The first column of my excel sheet contains the number of units (integers); the second column has the despatch date; and the third column contains the due date with time (e.g. 6/29/10 10:38). I'm interested in counting the number of units not yet despatched. That is: count "the number of units"...
Back
Top