Projected Business Days

  • Thread starter Thread starter umm_ism
  • Start date Start date
U

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!
 
Back
Top