Thanks again Roger

Yes...mails were indeed crossing! Thanks for you input!.

I do have another question however....apologies I am a bit of an Excel
novice.

If I have 2 columns where A is the date I enter and B is the formula to
calculate week commencing.

I want to make sure that column B is automatically calculated so I
pasted the formula into the entire column. No problem for the cells in
column A that actually have a value in but for those that have not yet
any entry (i.e this is a spreadsheet that will have rows manually added
to it) I get the ########### entry in column B simply because the
formula cannot get a value because the cell in column A has no value.

2 questions
- Can I suppress the #########
- Can I prevent users changing anything in the "formula" column (B).

I'll happily post this again as a separate thread if required.

Many thanks all.

Jules


--
JulesM
------------------------------------------------------------------------
JulesM's Profile: http://www.excelforum.com/member.php...o&userid=27609
View this thread: http://www.excelforum.com/showthread...hreadid=471344