Ask Your Question

To say return this day - 7 days in Spreadsheet [closed]

asked 2015-01-05 08:40:55 +0200

Masi gravatar image

updated 2020-07-30 00:33:59 +0200

Alex Kemp gravatar image

I am trying to list all days of lotteries in Eurojackpot history which is every sunday.

So last day when played 2.1.2015.

Pseudocode where edate is not the function of Libreoffice, since it only supports months

edate(date(2015,1,2); ; -7)

where syntax edates( [date]; [monhts]; [days]).

How can you minus seven days from timestamp in Spreadsheet?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-07-30 00:34:21.368945

1 Answer

Sort by » oldest newest most voted

answered 2015-01-05 08:54:03 +0200

karolus gravatar image

simply with =DATE(2015;1;2)-7


edit flag offensive delete link more

Question Tools

1 follower


Asked: 2015-01-05 08:40:55 +0200

Seen: 110 times

Last updated: Jan 05 '15