I have a number of hours remaining on a task (Ex: 60 hours).
The working Day are Monday to Friday, we are estimating that we can only work 6 hours by working day.
2011-03-02 I have 60 hours remaining
so I have 10 working day left to work
The task should be finish on 2011-03-15
How can I calculate the completion date in SQL 2005?
-- SOMETHING LIKE THIS
DECLARE @RemainingHours FLOAT
SET @RemainingHours = 60
DATEADD(DD, @RemainingHours / 6 * 1.40, GETDATE())