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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DateAdd function only to add Business Days

Status
Not open for further replies.

ronnutter

Technical User
Aug 30, 2001
15
US
I've looked everywhere for this function.
Is there a way to only add business days to a date?

thanks,
Ron
 
See my post about UFLs - User Function Libararies. Visit the following site:


There is a UFL there for "Workday". You should be able to create a formula along these lines:

IF workday({date})Not in ([6,7]) then DateAdd({Date}) else {date}

Let me know if you have any questions.

Don Software Support for Sage Mas90, Macola, Crystal Reports and Goldmine
Cell/VM: 714-348-0964
 
thanks Don,

I went to the website but was unable to find the
workday UFL you mentioned. Please list the file
name.

thanks for your help,
Ron
 
ufldate.exe....give me an email address and I email it to you. Software Support for Sage Mas90, Macola, Crystal Reports and Goldmine
Cell/VM: 714-348-0964
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top