Specific Dates

[Dos Equis]

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

 

[Ron Rosenfeld]

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

 

[Dos Equis]

=A1-WEEKDAY(A1)-2

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

Works like a champ. Thank you.