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

Tap the Share icon in Safari
Scroll the menu and tap Add to Home Screen.
Tap Add in the top-right corner.

To install this app on Android

Tap the 3-dot menu (⋮) in the top-right corner of the browser.
Tap Add to Home screen or Install app.
Confirm by tapping Install.

FMForums.com

Sign In

Email Address

Password

Remember me
Not recommended on shared computers

Forgot your password?

Or sign in with...
Sign Up

Week Number Ranges Multikey

Followers

February 8, 201016 yr

Newbies

I have attached an extract from my database. I've successfully managed to implement a calculation field that calculates all the dates between the from and end date fields (courtesy of Andrew Persons, Excelisys from Brian Dunning's custom functions). Now I'd like to add a field which will calculate the week numbers which are between the from and end dates. I have managed this with some success by modifying the date range calculation. However, this calculation does not seem to work properly in all situations. In particular it does not work correctly when the from date field and end date are in different years. The date range calculation works flawlessly, but the week range does no function in this instance. Does anyone have experience of implementing such a calculation or can anyone help with correctly modifying this calculation?

WeekNoRanges.zip