How to Automatically determine the date of the most recent

[Mopacs]

Hello again,

I have a question...is there a built-in function in Excel or a macro that can automatically determine the date of the most recent saturday?

For instance, say I run a particular report this coming Monday - April 1st(not always on monday, could be any day of the week). There is a header in the spreadsheet that says "Data as of MM/DD/YYYY" where the date is the most recent saturday relative to that day (april 1st)..where the date would display as "03/30/2002". Is there a way to dynaically determine this date.. regardless of what day the report is run, relative to the previous saturday?

Thanks in advance,

Rob

 

[Dave Patton]

Try one of the following; edit references and text as necessary.

="Data as of : "&TEXT(TODAY()-WEEKDAY(TODAY(),3)-2,"ddd dd mmm yyyy")

="Data as of : "&TEXT(A50-WEEKDAY(A50,3)-2,"ddd dd mmm yyyy")
This message was edited by Dave Patton on 2002-03-29 11:08

 

[Mopacs]

On 2002-03-29 11:06, Dave Patton wrote:
Try one of the following; edit references and text as necessary.

="Data as of : "&TEXT(TODAY()-WEEKDAY(TODAY(),3)-2,"ddd dd mmm yyyy")

="Data as of : "&TEXT(A50-WEEKDAY(A50,3)-2,"ddd dd mmm yyyy")
This message was edited by Dave Patton on 2002-03-29 11:08

BOTH of those worked to perfection.. THANKS!

Rob