Date Formula

[Bennets04]

Hi all,

Merry Christmas!!!

I was wondering if you lovely people had any ideas on a formula i can use that will run down a list of dates and tell me the day (example Monday) then also know if its the Monday the previous week then Monday -1 and the monday the week before so Monday -2

So for example:
10/12/2018 - Monday -2
11/12/2018 - Tuesday -2
12/12/2018 - Wednesday -2
13/12/2018 - Thursday -2
14/12/2018 - Friday -2
15/12/2018 - Saturday -2
16/12/2018 - Sunday -2
17/12/2018 - Monday -1
18/12/2018 - Tuesday -1
19/12/2018 - Wednesday -1
20/12/2018 - Thursday -1
21/12/2018 - Friday -1
22/12/2018 - Saturday -1
23/12/2018 - Sunday -1
24/12/2018 - Monday
26/12/2018 - Wednesday

Im looking to then pivot the data so i can show movement day on day and week on week (by day)

Hope that makes sense

Cheers
Steve

 

[gaz_chops]

Re: Data Foruma

Try

=TEXT(A1,"dddd")&" "&WEEKNUM(A1,2)-WEEKNUM(TODAY(),2)

 

[Bennets04]

Re: Data Foruma

Genius!!! You deserve a beer my friend lol

Thank you

 

[gaz_chops]

Re: Data Foruma

You're welcome & cheers