Specific Dates

D

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
 
R

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
Click to expand...


=A1-WEEKDAY(A1)-2

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