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