days of the week formulas
End of Period:
=A1+39-DAY(A1+32)-WEEKDAY(A1+32-DAY(A1+33))
I do not believe this formula works all the time. Unless I am wrong, it
fails for dates like 2/28/2008 through 3/1/2008, 3/29/2008 through
4/1/2008,
4/29/2008 through 5/1/2008, and so on.
Rick
You're correct, and <slap upside the face I've made that same %$#^&$
mistake
before.
Should be:
=A1-DAY(A1)+39-DAY(A1-DAY(A1)+32)-WEEKDAY(A1-DAY(A1)+39-DAY(A1-DAY(A1)+33))
I think there are still problems with that one too. Try the first of each
month (2/1/2008, 3/1/2008, 4/1/2008, etc.)
Rick
|