Specific Dates
 

Hi all,

Just realized, I also need help with another aspect of my project. I
need to print a report which always refers to the previous Thursday.
Specifically, in the header I have "Report for (Date)" where (Date) is
the previous Thursday. I'd like to automate the dating process as I
forget as often as I remember. Again, any help is greatly
appreciated.

Thanks,

Byron

Specific Dates
 

On 14 Mar 2007 09:43:50 -0700, "Dos Equis" wrote:

Hi all,

Just realized, I also need help with another aspect of my project. I
need to print a report which always refers to the previous Thursday.
Specifically, in the header I have "Report for (Date)" where (Date) is
the previous Thursday. I'd like to automate the dating process as I
forget as often as I remember. Again, any help is greatly
appreciated.

Thanks,

Byron


=A1-WEEKDAY(A1)-2

will give the Thursday preceding the date in A1
--ron

Specific Dates
 

On Mar 14, 12:49 pm, Ron Rosenfeld wrote:
On 14 Mar 2007 09:43:50 -0700, "Dos Equis" wrote:

Hi all,

Just realized, I also need help with another aspect of my project. I
need to print a report which always refers to the previous Thursday.
Specifically, in the header I have "Report for (Date)" where (Date) is
the previous Thursday. I'd like to automate the dating process as I
forget as often as I remember. Again, any help is greatly
appreciated.

Thanks,

Byron

=A1-WEEKDAY(A1)-2

will give the Thursday preceding the date in A1
--ron

Works like a champ. Thank you.