View Single Post
  #5   Report Post  
Agostino Banchi Agostino Banchi is offline
Junior Member
 
Posts: 1
Default

I had the same problem and I did not find any solution on internet.
So I wrote this procedure.

Sub Y1904()

For Each Sht In ActiveWorkbook.Sheets
Set Rng = Sht.UsedRange
For Each cell In Rng
If cell.HasFormula = False Then
If IsDate(cell.Value) Then
cell.Value = cell.Value + 1462
End If

End If

Next
Next
End Sub

Basically it adds to all cells containing a date (not formula) the 1462 value.