I have placed a command button on sheet1 when clicked I need it
to insert todays date i.e. = today() into cell J2

Is it a Visual Basic CommandButton? If so, in Design Mode, use this Click
event code...

Private Sub CommandButton1_Click()
Range("J2").Value = Date
End Sub

Rick