If and date functions help needed please

[chriscavell]

Hi
I know this has been asked somewhere before (I was google searching earlier but cant find it now) but I have a spreadsheet which logs all the invoices my department receives and their relevant pieces of information.
One column, is the current status (ie who has the invoice to sign off and whether it has been approved or not). I want to enter a formula into the 'date sent to accounts' column so that when the current status column says 'yes' the 'date sent to accounts column' automatically enters the date (obviously I don't want this date to change once entered).

I have tried entering an IF statement including the date but cant get it to work.

Can anyone help?

Thanks

 

[lenze]

If "Yes" is entered manually in Column "K", then this code is all you need!!

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Column <> 11 Then Exit Sub    
If UCase(Target) = "YES" Then Cells(Target.Row, 14) = Date 
End Sub

You do not need a formula in Column "N"

lenze