
Contributor
2018-11-30
09:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Calculating completed number of weeks between two dates
Is anyone able to help with this, please?
I have a field called clinic date and I want to calculate the number of completed weeks between current date and the prospective clinic date.
Many thanks in advance,
Laura
2,269 Views
1 Reply


Specialist
2018-11-30
10:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Maybe something like
=Floor(Interval( Prospective_ClinicalDate-Today(), 'DD')/7)
