• 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.

Calculate no.of days present week-wise

A

ashish navale

New Member
Hi,

I have a production tracker which is used to maintain work done daily by employees in the project. There are multiple entries for same date in this excel. The thing is that my Manager wants week-wise attendance of employees in same excel but different sheet. There are four boxes named as 1st week, 2nd week, 3rd week, 4th week. In the boxes there are 2 columns. One is name of employees and other column is no.of days present in week.


I want a formula in column of No.of days through which I will get weekwise count of days present. Please help me out with a perfect solution. :)
 
Let's say you setup it up where your headers are the 1st date of the week you are interested in, such as "The week of the 14th". Then, the formula is:

=COUNTIF(DataRange,">="&Header_Date)-COUNTIF(DataRange,">"&Header_Date+6


Note that this formula is inclusive of the header date.
 
You must log in or register to reply here.
Back
Top