How to chart business days only

[Ruthie09]

I'm sure this is completely simple but here goes:  How do I chart only business days?

Right now, my expression is   =Date([IncCreated.autoCalendar.Date],'MM/DD/YY')  but I do not want to include weekends.  How do I do that?

Thanks!

[GaryGiles · Accepted solution]

With your expression, you could use:

=Date(if(Match(WeekDay([IncCreated.autoCalendar.Date]),'Mon','Tue','Wed','Thu','Fri')>0,[IncCreated.autoCalendar.Date]),'MM/DD/YY')

But it would more useful if you created a flag in your load script.  You would use the similar if statement logic in your load script.

[Ruthie09]

PERFECT!!!  Both ideas are excellent!  Thank you Gary!!!!!!!!!!!!!!!!