I simply cannot find the DateAdd function in Calc under LibreOffice Version: 6.4.7.2 (Linux Mint 20.1 version 4.8.6). I’ve tried using the Extension Manager but no luck.
Has the function been retired?
And that, as the sbasic in the URL indicates, is a BASIC function, the list in the right Content bar as well. The Sub example_dateadd
at the bottom also.
The newer 7.2 help has better indicators like the fully typed syntax and the BASIC context in the left bar.
It’s not necessary. Just add an amount of days to a date, or subtract two dates.
=TODAY()+42
=TODAY()-DATE(2021;1;1)