Ask Your Question
0

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

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

Masi gravatar image

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

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
1

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

karolus gravatar image

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

Karolus

edit flag offensive delete link more

Question Tools

1 follower

Stats

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

Seen: 102 times

Last updated: Jan 05 '15