Versions Compared

Old Version 2

changes.mady.by.user Frederick Harju

Saved on

compared with

New Version 3

changes.mady.by.user Frederick Harju

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info

Here are some formulas to calculate expiration by lapse time of 365 days. Cell K2 is assumed to be the timestamp cell.

Excel or LibreOffice: 

=DATE(LEFT(K2,4), MID(K2,6,2), MID(K2,9,2)) + 365

...