Would someone help me come up with a formula to subtact ten weekdays
(not counting Saturdays and Sundays) from the date I enter in an
existing date field? Thanks.

I'm sure someone will post the more complex calculation, but perhaps the
easiest way to think about this is that it is always 14 days total
(unless the base date is itself on a weekend).

JoelL wrote:
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Professional Solutions, Inc. Los Angeles

FileMaker 8 Certified Developer
Associate Member, FileMaker Solutions Alliance

In article <13617ho1fiaq74f (AT) corp (DOT) supernews.com>, Howard Schlossberg
<howard (AT) antispahm (DOT) fmprosolutions.com> wrote:
Yep, that's a very nice simple solution so there's no point in making
it more complicated than that.

TenWeekDayAgo = Date - 14

As well as the problem when Date is a weekend, there is one other
hiccup if you're counting the Date itself as one of those 10 days, but
you're probably not.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

On Jun 1, 4:03 pm, Helpful Harry <helpful_ha... (AT) nom (DOT) de.plume.com>
wrote:
Not that that its that much more complicated if the date is on a
weekend:

case(
DayOfWeek(date)=1, date-13,
DayOfWeek(date)=7, date-12,
date-14
)

-cheers,
Dave