Is there any Excel functions that can populate the last 3 weekdays in 3 cells?
Like:
A1=7/9/2012
A2=7/6/2012
A3=7/5/2012
Is there any Excel functions that can populate the last 3 weekdays in 3 cells? Like:



Method #1You could try these formulas in 3 cells:
Method #2This formula will return the last nTH weekday/workday.
Examples:
 If To see the days of the week along with the dates, try the following number formats:


