Is there a CF out there to count days by day names?

[Kent Searight]

Hi,

I was wondering if anyone's seen a CF that can count the number of days elapsed between two dates, and only counting the days of the week that are included in a list of return-separated values.

IOW 3 fields are referenced for the calc:

StartDate (include in count)

EndDate (include in count)

DaysOfWeek (checkbox of day names)

Example:

StartDate = "11/26/07"

EndDate = "12/3/07"

DaysOfWeek = "Monday¶Wednesday"

The result would be "3" because there are 3 days from the StartDate to the EndDate that are Mondays or Wednesdays or a combination thereof.

Thanks in advance for any help!

[Lee Smith]

There is no CF for this that I'm aware of. However, I don't believe you need one. There was a version 3/4 Tip File, I think was called Count Mondays. I found this link to a newer version though, Link That should get you going.

HTH

Lee

[comment]

You could try to adapt this:

http://www.briandunning.com/cf/452

It lists them rather than just count them, and it uses day numbers, not names.

[Kent Searight]

Hey Michael,

That's the one I had a recollection of seeing somewhere before.

Thanks!

-Kent