Wat did I forgot in this formula?

[Belleke]

=IF(WEEKDAY(TODAY(),2)=6,TODAY()-1) IF(WEEKDAY(TODAY(),2)=7,TODAY()-2)
I want to combine these 2 so that if it is weekend cell always returns last friday

 

[ETAF]

=WORKDAY(TODAY() +1,-1)

 

[p45cal]

try:
=TODAY()-MAX(0,WEEKDAY(TODAY(),2)-5)
or:
=WORKDAY(TODAY()+1,-1)
edit: beaten to it!

 

[Marc L]

Wat did I forgot in this formula?

What ? The Excel logic … Even if the way to go is post #2​

according to your logic your formula should be like =TODAY()-IF(WEEKDAY(TODAY(),2)>5,WEEKDAY(TODAY(),16),0) or​

​

=IF(WEEKDAY(TODAY(),2)=6,TODAY()-1,IF(WEEKDAY(TODAY(),2)=7,TODAY()-2,TODAY())) …​

​

 

[Belleke]

Thank you both for the assistance.

 

[Belleke]

@Marc L
I was in the hospital for 11 months, a lot of Excel Logic was lost there, hope it doesn't happens to you.

 

[bosco_yip]

Maybe

Try this old formula, without Weekday or Workday function

=TODAY()-SUM((MOD(TODAY(),7)+1={1,2})*{1,2})

or

=TODAY()-MID(1200000,MOD(TODAY(),7)+1,1)

 

[GraH - Guido]

I was in the hospital for 11 months, a lot of Excel Logic was lost there, hope it doesn't happens to you.

Sad to read this. Hope you recovered well, @Belleke.
Take Care.

 

[Marc L]

@Belleke : was just an answer to your question … Now you know at least with post #4 what you forgot in red …​

​

 

[S P P]

=IF(WEEKDAY(TODAY())=7,TODAY()-1);IF(WEEKDAY(TODAY())=1,TODAY()-2;TODAY()))

=TODAY()-WEEKDAY(TODAY(),2)+LOOKUP(WEEKDAY(TODAY(),2),{1;2;3;4;5})