Skip to Content
0
Former Member
Jan 12, 2008 at 05:18 PM

Need Help with "weekly" inspection calculations

22 Views

Post Author: Kathleen

CA Forum: Formula

Hello. I have an inspection that is done weekly (depth of pool water). The staff can do this inspection any time from Sunday to Saturday as long as it is completed once every calendar week. It does not have to be once every seven days. The date of the inspection will be entered into Casper (InspDate) along with the results (PoolDepth) along with the DTS that will include the initials of the staff who entered the information, time of entry and date of entry.

How do I create a formula (or it may be two formulas) that do the following?

#1 Calculate whether or not an inspection was completed during each calendar week for the year?

I think I can then calculate the IF/Then statements that will come after. I've looked at all the date fields in the formula creater and don't see anything that will work without requiring the date to be every seven days.

Thanks in advance for your advice.