Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Defining Range within Specific Dates | Excel Worksheet Functions | |||
how do i get the sum of data from specific dates | Excel Worksheet Functions | |||
Cells populate on specific dates | Excel Worksheet Functions | |||
Counting occurences of a specific day between two dates | Excel Worksheet Functions | |||
Counting columns and specific Dates | Excel Worksheet Functions |