Solved: Excel 2007 If today is Monday show the previous Friday's date

[Ike]

Hello All,

I would like a VBA that would do the following in cell I31.

I want the cell to populate the last working day's date.
Work days = Monday through Friday.

On Monday it would populate Friday's date. On Tuesday it would populate Monday's date, etc.

Thank you In Advance.

Ike

[mancubus]

hi ike.
you dont need vba.

try
=WORKDAY(TODAY(),-1)
formula.

[Ike]

Perfect. Thank you very much.