N
N
Noir2019-06-18 08:35:21
Google Sheets
Noir, 2019-06-18 08:35:21

How to indicate the beginning and end of the last week in the cells?

for example week 23 in cells 1 07 2019 and 7 07 2019 if week 24 then 8 07 2019 and 15 07 2019 the date example is simple

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander, 2019-06-18
@PolarBearGG

start of week =A1-ДЕНЬНЕД(A1)+2
end of week =A1-ДЕНЬНЕД(A1)+8
for the previous -7 days:
start =A1-ДЕНЬНЕД(A1)-5
end =A1-ДЕНЬНЕД(A1)+1
The numbers depend on which day the week starts from in the date settings.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question