Is there any Excel functions that can populate the last 3 weekdays in 3 cells?
A1=7/9/2012 A2=7/6/2012 A3=7/5/2012
You could try these formulas in 3 cells:
This formula will return the last nTH weekday/workday.
To see the days of the week along with the dates, try the following number formats: