Previously, I asked about finding a date after x business days. But, to Gustav's point, "for longer intervals you typically count in weeks or months," I believe that for the intervals of weeks and months, it would be better to use those units of measure.
How could I modify the solution here to include weeks and months?
The interval is coming from a drop down in the cboPriority.Column(2) field.
Me!FollowupDate.Value = DateAddWorkdays(Val(Me!cbo
currently they are all listed as business days
5 (1 week)
15 (3 weeks)
44 (1 month)
I really don't know what would be a good way to refer to weeks or months while indicating a change in unit of measure from days.
Is it best just to leave it as days? I was just looking for a more precise way that a person could look at the difference between the opening date and the follow up date and say, yes, that is 3 weeks or 2 months between, etc.
Maybe refer to it all as years? 1 day = 1/365, 1 week = 1/52, and 1 month = 1/12.
The difference is that while 1 - 4 business days would skip weekends and holidays, anything a week longer would be strictly that, measured in weeks or months only, but to be sure the follow-up date ended on a weekday.