If yesterday is a Sunday return Fridays date otherwise Return yesterdays date

**DeanMcK** · 07-10-2022, 05:54 PM

Hi All,

I need to open a file with yesterdays date except on a Monday when I need to open the Friday file.

I have the following code that opens last Sundays but not sure how to manipulate it to return Friday date when it today is Monday.

My original code is Sub Test2 which returns yesterdays date but I forgot we don't produce files on the weekend.

Please Login or Register  to view this content.

[/CODE]

Any help appreciated

Cheers

Dean

**protonLeah** · 07-10-2022, 06:45 PM

Choose(weekday(date,2),3,1,1,1,1,1,2)?

**Artik** · 07-10-2022, 06:54 PM

For example

Please Login or Register  to view this content.

or the short version

Please Login or Register  to view this content.

Artik

**bebo021999** · 07-11-2022, 12:10 AM

Why not use workday function?

HTML Code:

**DeanMcK** · 07-11-2022, 06:59 PM

Thankyou all for your suggestions @Artik I used your code in the end, short version, but all work just as well as each other.

Cheers

Dean

If yesterday is a Sunday return Fridays date otherwise Return yesterdays date

LinkBack

Thread Tools

Rate This Thread

Display

If yesterday is a Sunday return Fridays date otherwise Return yesterdays date

Re: If yesterday is a Sunday return Fridays date otherwise Return yesterdays date

Re: If yesterday is a Sunday return Fridays date otherwise Return yesterdays date

Re: If yesterday is a Sunday return Fridays date otherwise Return yesterdays date

Re: If yesterday is a Sunday return Fridays date otherwise Return yesterdays date

Thread Information

Users Browsing this Thread

Similar Threads

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

[SOLVED] Return next Sunday's date beginning this Friday.

[SOLVED] Dates in Excel - If Saturday or Sunday, return Friday's date

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

[SOLVED] Add days to a date but not letting it return a Sunday

shows fridays date not sunday (or last working day)

[SOLVED] Formula to return a True/False if date equals yesterday's date

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions