Help

[RelapseWizard]

I'm creating an excel sheet for one of my dep heads hope someone can help so here goes. What I want to do is when a user enters the date on the "referral date" field a code that auto populates the "referral month" field like example, hope some one can help its doing my head in arrgh all this is in excel 2000 by the way.

 

[Brianwarnock]

I read your post before you edited it and your approach seemed fine.
Format field with custom format mmm
place =If(a1<>"",A1,"") in B1 this is to prevent Jan appearing when A1 is null

conditional format I would check B1 <> ""

Brian

 

[RelapseWizard]

WOW it worked thanks a lot Brian.....