>That worked! So, it seems to be the subtracting-the-day-from-the-date part that doesn't work. I tested it, and the DAY function returns the correct day of the month, but when subtracted, it comes up with yesterday, just the same as my calculation, even though my calculation was also adding a 1.
>
>I just figured it out while testing. COM must be using DATETIME instead of DATE. I calculated the number of seconds in 22 days (1,900,800) and subtracted, and got the correct date.
>
Yep, it is using datetime.
>Thanks for your help!
You're welcome...
Steve Gibson