Tom,

Thanks for the reply but I am not sure what and how to use the
month(date) as you describe. I have searched the internet forums for a
solution but I am still in the dark.

Is it correct to place month(9) as september?
Where do I put in the month() function?

could you do a small example for me please.

As I explained previously I have a form which the user must complete on
a monthly basis. if he changes any of the data in the current month
then it must be accepted, but if he opens the form again and the month
has changed to say October then he can only update data to the October
column.

I have attached the spreadsheet in question which will make it clear.
Thanks again
Andre

File Attached: http://www.exceltip.com/forum/attach...?postid=280197 (ref_alrev1.xls)

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/