B Barbara Jan 21, 2004 #1 I am trying to calculate the number of days past minus Saturday and Sunday. Is there a formula for that?
I am trying to calculate the number of days past minus Saturday and Sunday. Is there a formula for that?
D Douglas J. Steele Jan 22, 2004 #2 Check the Date/Time section of "The Access Web" http://www.mvps.org/access/ There are a couple of approaches outlined there.
Check the Date/Time section of "The Access Web" http://www.mvps.org/access/ There are a couple of approaches outlined there.
V Van T. Dinh Jan 22, 2004 #3 See The Access Web article: http://www.mvps.org/access/datetime/date0006.htm
D Dirk Goldgar Jan 22, 2004 #4 Barbara said: I am trying to calculate the number of days past minus Saturday and Sunday. Is there a formula for that? Click to expand... If I understand your question, it's more complicated than it might at first appear. Fortunately, Ken Getz has written some functions for doing "workday math" and posted them here: http://www.mvps.org/access/datetime/date0012.htm
Barbara said: I am trying to calculate the number of days past minus Saturday and Sunday. Is there a formula for that? Click to expand... If I understand your question, it's more complicated than it might at first appear. Fortunately, Ken Getz has written some functions for doing "workday math" and posted them here: http://www.mvps.org/access/datetime/date0012.htm
