Projected Business Days

[umm_ism]

I am currently projecting a date in a query that is 30 days prior to the
field [Start Date] using this formula: DateSerial(Year([Start Date]),Month(
[Start Date]),Day([Start Date])-30)

I would like to project 30 business days prior instead. I found the
following formula on this website, which works to calc business days between
two dates.
DateDiff("d", dte1, dte2) - DateDiff("ww", dte1, dte2, 1) * 2 - IIf
(Weekday(dte2, 1) = 7, IIf(Weekday(dte1, 1) = 7, 0, 1), IIf(Weekday
(dte1, 1) = 7, -1, 0))

Can I someway combine my formula with this one to figure 30 business days
prior?

Thanks so much!

 

[Michel Walsh]

Hi,

Have you explored the various VBA subroutines in
http://www.mvps.org/access/datetime/date0012.htm ?


Hoping it may help,
Vanderghast, Access MVP