Calculate dates in access 2010
Posted on 2011-10-30
I'm completely clueless on how to use vba in the background to calculate some dates.
I have 7 fields that this needs to be done too. Some fields need to exclude weekends and holidays and one field needs to find the nearest Tuesday and find the nearest Thursday.
Field 1 - DayWorkCompleted = Date input by user, ex September 1,2011
Field 2 - StorageBeginsOn = 4th business day excluding weekends and holidays - September 7
Field 3 - PublicationDate = Will vary per County - Septemebr 13
Field 4 - PublishedDate = Date newspaper will publish the legal notice - September 15
Field 5 - AuctionDate = 18 complete days from the date of the published legal notice - October 3
Field 6 - NOCSent = Certified letters must be sent at least 15 prior to the auction date - September 16
I need this to calculate automatically once a date is entered into DayWorkCompleted. I'm completely clueless how to do this.