Rounding date formula results
On Mon, 12 Jan 2009 18:55:01 -0800, martin
wrote:
I am putting together a project plan in Excel. The task dates are driven by
the selected due date. I would like to enter the due date and have the
remaining dates populate based on pre-determined values. However, is it
possible to prevent these values from falling on a weekend (e.g. round to the
nearest workday?)
Take a look at the WORKDAY function. (If you try it and get a #NAME! error,
check HELP for the function to correct it).
A1: Seed date
A2: =WORKDAY(A1, pre-determined_value_in_days) will yield the next working
day. There is also an optional [holidays] argument you may want to use.
--ron
|