Ask Your Question

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

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

karolus gravatar image

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


edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 77 times

Last updated: Jan 05 '15