Show 6th WorkingDay

[liltechy]

I am trying to automate a spreadsheet and need some assistance with a formula.

Here is what the answer should look like for July:

ALL ITEMS DUE BY 8:00AM ON THE 6TH WORKING DAY - AUGUST 9

This is my formula:

="ALL ITEMS DUE BY 8:00AM ON THE 6th DAY - "&UPPER(TEXT(WORKDAY(NOW(),-7),"mmmm d"))

I need it to always show the 6th working day, how do I accomplish this without having to adjust the formula each month regardless if it has 30, 31 or 28 days?

liltechy

 

[Dreamboat]

Scroll down to "Nth..."

http://www.cpearson.com/excel/DateTimeWS.htm

Anne Troy
Killer Coder Live Chat!

http://www.vbaexpress.com/forum/showthread.php?p=2121

 

[liltechy]

Thank you that did the trick.

liltechy