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
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