How to return yesterdays date unless today is monday then return previous fridays date

**ciaron178** · 06-10-2019, 09:18 AM

Hello,

I need a formula that will return yesterdays date like =today()-1 however if today is Monday i need it to return fridays date instead of sundays.

Hope this exlains it well enough.

Ciaron

**alansidman** · 06-10-2019, 09:26 AM

=if(weekday(today()=2),today()-3,today()-1)

**ciaron178** · 06-10-2019, 09:54 AM

Yes thats perfect thank you very much!

**Alvin Chung** · 06-10-2019, 10:07 AM

try =TODAY()-1-IF(WEEKDAY(TODAY(),2)=1,2)

--------------------------------------------------------------------------------
Please click on the small star icon below the post if the response helps

**KOKOSEK** · 06-10-2019, 10:15 AM

Originally Posted by alansidman

=if(weekday(today())=2,today()-3,today()-1)

I am not sure but closing bracket in condition should be like above.

How to return yesterdays date unless today is monday then return previous fridays date

LinkBack

Thread Tools

Rate This Thread

Display

How to return yesterdays date unless today is monday then return previous fridays date

Re: How to return yesterdays date unless today is monday then return previous fridays date

Re: How to return yesterdays date unless today is monday then return previous fridays date

Re: How to return yesterdays date unless today is monday then return previous fridays date

Re: How to return yesterdays date unless today is monday then return previous fridays date

Thread Information

Users Browsing this Thread

Similar Threads

Find Text Within Table, Return First Row Date, Then Compare to Today's Date

[SOLVED] Return Next Date After Today - No Arrays

[SOLVED] VBA Date of Previous Weeks Monday From Current Date

[SOLVED] Find yesterdays date in range and return row number to be used in offset

[SOLVED] Return the date of the previous Monday

[SOLVED] Display Fridays date (and message) if current date is Monday

Using Today Date to return YTD budget

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions