working dates!

  • Thread starter Thread starter victoriathomson
  • Start date Start date
V

victoriathomson

Hi! I'm not a very advanced computer user but am trying to make
library system! I'm trying to work out how to calculate the day a boo
is due back. The books have to be returned one calendar month afte
they are taken out but if this due date falls on a weekend then the du
date is changed to a monday! can anybody help?! I'd be very grateful i
you would post a reply,
Thank you so much,
Vicki
 
Vicki,

In a query, you can make a calculated field along these lines...
DueDate:
DateAdd("m",1,[DateOut])+IIf(Weekday(DateAdd("m",1,[DateOut]),2)>5,8-Weekday(DateAdd("m",1,[DateOut]),2),0)
 
Back
Top