Macro for doing a date stamp that isn't today

Hi All, I want to set up a macro that will input a date stamp for the working day before this one. I have to input the status of dozens of meeting rooms everyday and the checksheets that I work from are from the previous working day (So on a Monday, I want the Macro to enter Friday's date). I wanted to create a quick macro to save myself the hassle of entering the date for every entry and obviously, if I incorporate the TODAY() function it will update every time I open the workbook and give me the wrong date.

I've been checking related threads and can't seem to find either a VB code or a function that'll enable me to do this (I haven't looked particularly hard as I'm at work ). Any help would be greatly appreciated.

Plaasboy,

Is this what you're looking for ?

Please Login or Register  to view this content.

OOPS :
Should be :

Please Login or Register  to view this content.

Eddie

try this function

Please Login or Register  to view this content.