View Single Post
  #5   Report Post  
Paul Sheppard
 
Posts: n/a
Default


VDan Wrote:
I need a formula to calculate the date 30 business days from a given
date.
Any help appreciated.


Hi VDan

Try the Workday Function

If your date is in cell A1 you can enter in B! the following
=WORKDAY(A1,30)

This can also be adjusted for Holidays


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=400782