PDA

View Full Version : Calculating Days and Inactivating the columns



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

Bob Phillips
08-27-2008, 08:21 AM
Put this formula in B2 and copy down as far as you need

=IF(A2<>"",WORKDAY(A2,3),"")

then unlock the cells in column A, and set protection on the sheet.

k_v_deepu
08-27-2008, 08:28 AM
i dont have workday formula in my excel, what should i do

Bob Phillips
08-27-2008, 08:33 AM
Tools>Addins, check Analysis Toolpak

k_v_deepu
08-27-2008, 08:45 AM
its working thank u very much

Bob Phillips
08-27-2008, 08:47 AM
Next time, if you cross-post your problem, I for one will not be bothering to help you.