15 working days

[Mary_S_(Guest)]

I would like to create a calculation that will yield a date that is 15 working days from today^s date - wizDate. Any ideas on how to do that?__Thanks for help.

[kfleming]

You would need to create a calculation that uses the DOW() function to decide how many days to add.__So if the system date is a Monday DOW(date())=2 to get 15 working dates you would need to add 19 days to accomodate the two weekends. __The calc would then have and IIF() test so that each DOW() would add the appropriate number of calendar days.__And if there were any holidays you would need to specifically factor them in as well.____Sorry that it is just the concept and not the actual calculation.____Kathleen__R&R Support

[Mary_S_(Guest)]

Worked like a charm - I used AddDays() and did an iif calculated field for each DOW and stacked them.__Thanks a lot