...
| 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 |
Related articles
Microsoft Excel cell formatting: Format cells
LibreOffice cell formatting: Formatting data
| Filter by label (Content by label) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...