| Home |
| Search |
| Today's Posts |
|
#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. |
| 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 | |||
Threaded Mode
