Skip to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

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

Kent Searight
in Calculation Engine (Define Fields)

Featured Replies

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!

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

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.

  • Author

Hey Michael,

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

Thanks!

-Kent

Create an account or sign in to comment
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Account

Navigation

Search

Search

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.