Automatic Date Update (No Interaction)

Hi ldcox8551,

Alternatively, you can add a clock in your spreadsheet with a macro. This will write the current date in cell A1 and current date in cell A2. Since it refresh every second, your spreadsheet will recalculate every second. Execute "SetTime" to start the process and "Disable" to stop the process. 

Dim SchedRecalc As Date

Sub Recalc()

With Sheet1.Range("A1")

.Value = Format(Date)

End With

With Sheet1.Range("A2")

.Value = Format(Time, "hh:mm:ss AM/PM")

End With

Call SetTime

End Sub

Sub SetTime()

SchedRecalc = Now + TimeValue("00:00:01")

Application.OnTime SchedRecalc, "Recalc"

End Sub

Sub Disable()

On Error Resume Next

Application.OnTime EarliestTime:=SchedRecalc, Procedure:="Recalc", Schedule:=False

End Sub

P.S. I copied this macro from another source. 

ldcox8551 

Any data source can be set to auto-refresh and almost all data sources have a system time function that can be returned to Excel using MS Query or PowerQuery. Here is the PQ example:

1.  In Excel use menu option: Data > New Query > From other sources > Blank Query
2.  In PQ use menu option Advanced Editor and make this edit
   let
   Source = DateTime.LocalNow
   in
   Source
3. Click Done
4. Click Invoke
5. Click File > Close & Load
6. In Excel click Table Tools Design > Properties
7. Click small icon (connection properties) next to Name:
8. Check Refresh Every and set to 1 minutes
9. Click OK twice to close properties

You now will have the current date updated every minute automatically. You can add formulas to calculate time elapsed from the "Invoked Function" table.