Annual/Biennial Date Calculations

[littleitaly5588]

Hoping someone has an easy solution to finding annual and biennial dates where the result omits weekends and possibly holidays.

Any help is appreciated.

[comment]

Your question is not clear enough.

[Pirsqed]

I think I understand what you mean. You are totaling the number of workdays, and don't want to include the weekends or holidays.

comment is right, though, we need more information to know exactly how to work it in this particular case.

I did this recently with a report layout I made. In it I have two date fields, a start and a stop. I use these date fields for calculating a find string so I get records between the two dates. It's easy enough to use WeekofYear(enddate) - WeekofYear(startdate) x2 to get the number of weekend days and subtract them from just the enddate - startdate + 1 to get the number of workdays.

Of course, that breaks if you cross a year, but a quick case statement can fix that, too.

Holidays were a harder task until I realized I was working in FileMaker, and I just made a new table to store holiday dates, then cycle through them to see if any fall between the start and end dates. You have to add the holidays manually, of course, but you only have to do it once.

Let us know if this helps or, if not, what would help.

[The Big Bear]

try the calculation engine section and search for the nextworkday topic by Bcooney and download the zip file she posted by Comment and see if this is want you want.