Every week I have to create a schedule that includes dates. I want to be able
to prompt for a date and place it within the header along with the phrase
"Week Ending". So I would open up the spreadsheet, and then get a prompt me
to enter a date and then I would take that date and make the phrase "Week
Ending December 4, 2008" for instance. Or, would I have to use control key
combination to get the date? I would also need to take that date and update
the date fields for each day of the week. The date would be Thursday, so I
would take that date and put it in the cell for the Thursday date. I would
then subtract one to automatically give me the date for Wednesday and so on.
Thanks for any help.

Not sure what you want.

If you want the Thursday date of the current week:

="Week ending "&TEXT(5-WEEKDAY(NOW())+TODAY(),"m/d/yyyy")

--
Biff
Microsoft Excel MVP


"Capture a variable date & use with text" <Capture a variable date & use
with (E-Mail Removed)> wrote in message
news:0CDC156D-BA3A-40F6-A486-(E-Mail Removed)...
> Every week I have to create a schedule that includes dates. I want to be
> able
> to prompt for a date and place it within the header along with the phrase
> "Week Ending". So I would open up the spreadsheet, and then get a prompt
> me
> to enter a date and then I would take that date and make the phrase "Week
> Ending December 4, 2008" for instance. Or, would I have to use control key
> combination to get the date? I would also need to take that date and
> update
> the date fields for each day of the week. The date would be Thursday, so I
> would take that date and put it in the cell for the Thursday date. I would
> then subtract one to automatically give me the date for Wednesday and so
> on.
> Thanks for any help.

That was close to what I want, but if I run this on Tuesday or Wednesday, I
want the Thursday to be next weeks Thursday. I also want to be able to
capture that date and use it to calculate the dates of next week. Thanks

"T. Valko" wrote:

> Not sure what you want.
>
> If you want the Thursday date of the current week:
>
> ="Week ending "&TEXT(5-WEEKDAY(NOW())+TODAY(),"m/d/yyyy")
>
> --
> Biff
> Microsoft Excel MVP
>
>
> "Capture a variable date & use with text" <Capture a variable date & use
> with (E-Mail Removed)> wrote in message
> news:0CDC156D-BA3A-40F6-A486-(E-Mail Removed)...
> > Every week I have to create a schedule that includes dates. I want to be
> > able
> > to prompt for a date and place it within the header along with the phrase
> > "Week Ending". So I would open up the spreadsheet, and then get a prompt
> > me
> > to enter a date and then I would take that date and make the phrase "Week
> > Ending December 4, 2008" for instance. Or, would I have to use control key
> > combination to get the date? I would also need to take that date and
> > update
> > the date fields for each day of the week. The date would be Thursday, so I
> > would take that date and put it in the cell for the Thursday date. I would
> > then subtract one to automatically give me the date for Wednesday and so
> > on.
> > Thanks for any help.
>
>
>

Sorry, I don't understand.

?????

--
Biff
Microsoft Excel MVP


"Capture a variable date & use with text"
<(E-Mail Removed)> wrote in message
news:87B922E0-4FF8-4914-8283-(E-Mail Removed)...
> That was close to what I want, but if I run this on Tuesday or Wednesday,
> I
> want the Thursday to be next weeks Thursday. I also want to be able to
> capture that date and use it to calculate the dates of next week. Thanks
>
> "T. Valko" wrote:
>
>> Not sure what you want.
>>
>> If you want the Thursday date of the current week:
>>
>> ="Week ending "&TEXT(5-WEEKDAY(NOW())+TODAY(),"m/d/yyyy")
>>
>> --
>> Biff
>> Microsoft Excel MVP
>>
>>
>> "Capture a variable date & use with text" <Capture a variable date & use
>> with (E-Mail Removed)> wrote in message
>> news:0CDC156D-BA3A-40F6-A486-(E-Mail Removed)...
>> > Every week I have to create a schedule that includes dates. I want to
>> > be
>> > able
>> > to prompt for a date and place it within the header along with the
>> > phrase
>> > "Week Ending". So I would open up the spreadsheet, and then get a
>> > prompt
>> > me
>> > to enter a date and then I would take that date and make the phrase
>> > "Week
>> > Ending December 4, 2008" for instance. Or, would I have to use control
>> > key
>> > combination to get the date? I would also need to take that date and
>> > update
>> > the date fields for each day of the week. The date would be Thursday,
>> > so I
>> > would take that date and put it in the cell for the Thursday date. I
>> > would
>> > then subtract one to automatically give me the date for Wednesday and
>> > so
>> > on.
>> > Thanks for any help.
>>
>>
>>