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 wrote in message
...
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 wrote in message
...
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"
soft.com wrote in message
...
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 wrote in message
...
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.