Update a cell automatically when changes are made to spreadsheet|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Do you want any manual change to increase the version number by 1 and update the date to the current date? If so, open the VB Editor (Alt+f11), locate your workbook in the Project Explorer window and double-click the ThisWorkbook object, then paste this in (and adjust the referenced cells as required):

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
On Error GoTo reset_events
' turn events off to prevent recursion
Application.EnableEvents = False
' assumes first sheet has the version number and date
With Sheets(1)
' version number - change range as necessary
.Range("A2").Value2 = .Range("A2").Value2 + 1
' current date
.Range("B2").Value = Date
End With
reset_events:
Application.EnableEvents = True
End Sub

Please note: this will be triggered by every change you make, so you might be better off with a manual routine that you run whenever  you want the version and date updated.