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

Tally of days in a month

W

Wulluby

Member
Hello Chandooins!

I have a question about tallying dates, with this one whenever I try to google it I am always overwhelmed with solutions on how to calculate the difference between 2 dates which is not what I am after.

I have in column A a long list of dates, and column C contains a task performed on that day. There can be more than one task performed on a day, I am trying to calculate from column A how many days in a month are worked. I need to do this with a formula.

Any pointers would be appreciated.

Thanks.
 
Thanks for the input Somendra, the resulting answer should be 3 as only 3 days are worked in October in this sample.

The 'Task performed' column should only hold 1 task, in the main file this is a drop down option that looks at a validation list of main tasks that may be performed in any given day. There is also additional info such as times etc but at the moment I am just looking for a way to tally how many days in a month have been entered in column A, in this case 3 (9th, 10th and 13th of October).
 
See the file, so basically you require unique date count, this was not clear from your post. Green cell has formula.

Regards,
 

Attachments

  • Day Tally.xlsx
    16.9 KB · Views: 10
If I change A2 in your sample to 09-Sep-14, the result in D3 changes from 3 to 4 when it should remain as 3. If I then change another date, lets say A11 to 01-Nov-14 then the result in D3 again increases to 5.
 
I think there is a confusion:

If you change A2 to 09-Sep-14 than also your list has 09-Oct-14,10-Oct-14 & 13-Oct-14 so 3. If you change A11 to 01-Nov-14 than also your list will be having 09-Oct-14,10-Oct-14 & 13-Oct-14 so 3. It is not increasing.

Regards,
 
My mistake, I touched it and took the array off the formula forgetting to put it back.

This works great, thanks.
 
You must log in or register to reply here.
Back
Top