Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to add three business days to a system date

Status
Not open for further replies.

Heeeeelp

Technical User
Jan 5, 2006
39
CA
Hi Everyone

I have a field named date that captures the system date, as per the date a file is opened. I have a second field named Follow Up Date. I need this field to show a date which is calculated by taking the system date that is stored in the date field and adding three business days to it (excluding the weekends).

Can someone please tell me how I could go about doing this. I'd really appreciate the help.

Tess
 
Have a look at this faq faq705-3213 - using this, you can also include other holidays in the calculation.

Roy-Vidar
 
Thank you Roy. It's working now. I appreciate your help.
Tess
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top