Ask Your Question
0

To say return this day - 7 days in Spreadsheet

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

Masi gravatar image

updated 2015-01-05 11:11:54 +0200

karolus 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 close merge delete

1 Answer

Sort by » oldest newest most voted
1

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

karolus gravatar image

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

Karolus

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 72 times

Last updated: Jan 05 '15