k_v_deepu
08-27-2008, 08:15 AM
hi everybody,
i have 2 columns one column contains date and other 3 days ahead of the date
example
Alloted_Date Completion_Date
27.08.08 30.08.08
i require 2 things
(1) i want a formula which calculates completion_date I,e. alloted_date + 3 days and if there is a saturday or sunday inbetween it should not take that into account
(2) i want to make Completion_Date column inactive once i enter the formula so that no body can edit the column
can somebody help me, thanks is advance
i have 2 columns one column contains date and other 3 days ahead of the date
example
Alloted_Date Completion_Date
27.08.08 30.08.08
i require 2 things
(1) i want a formula which calculates completion_date I,e. alloted_date + 3 days and if there is a saturday or sunday inbetween it should not take that into account
(2) i want to make Completion_Date column inactive once i enter the formula so that no body can edit the column
can somebody help me, thanks is advance