WORKDAY Function for FRIDAY

[BillTony]

Hi there!

Might be a rather simple question - but has been causing me a TON of trouble...

I have a report that is published every weekday - it usually needs to capture the previous BUSINESS DAY, but on MONDAY, needs to reflect the previous FRIDAY (or, business day...).

Seems pretty simple, but, no luck thus far!

So... On Monday it is basically Today -3, on Tuesday it is Today -1, etc.

Probably something VERY basic here that I'm not connecting with...

 

[crazydragon84]

try workdays function. you can also incorporate a holiday list with that.

 

[BillTony]

Would you have any type of SYNTAX example of that - that would, indeed, be the basic premise of the QUESTION...

 

[AhoyNC]

See if this helps.
WORKDAY.INT lets you choose which days to use for the weekend. Both functions allow you to enter holidays. See help on the functions.

Excel Workbook
	A	B	C
1	Thursday, April 26, 2018
2	or
3	Thursday, April 26, 2018
4
5	Other Examples
6	Saturday, April 21, 2018	Friday, April 20, 2018	Friday, April 20, 2018
7	Sunday, April 22, 2018	Friday, April 20, 2018	Friday, April 20, 2018
8	Monday, April 23, 2018	Friday, April 20, 2018	Friday, April 20, 2018
9	Tuesday, April 24, 2018	Monday, April 23, 2018	Monday, April 23, 2018
Sheet

 

[BillTony]

Thanks - this is a great help.