View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mark73181 mark73181 is offline
external usenet poster
 
Posts: 1
Default Date Functions in Excel


Hi guys, I have a question. I couldn’t find an answer on previous post
so I’m assuming it hasn’t been discussed before.

I have a weekly worksheet I do for a game me and my friends play
mainly to keep scores. We have a column for each day and we save th
files based on the week ending date.

My question is how I can have the Week Ending Cell change th
individual dates in each column based on the actual end of the wee
date. Then I need the file name to be automatically updated based o
the end of the week date as well. My filenames are in this forma
“GameWE_071406.xls”. The problem I am facing is that excel doesn’t see
to let me just type in 071406 as a date and keep it that way, i
converts it to 07/14/06 or changes it completely.

Is there a way to do this?

Any help would be appreciated.

Thanks a lot,
Mar

--
mark7318
-----------------------------------------------------------------------
mark73181's Profile: http://www.excelforum.com/member.php...fo&userid=3638
View this thread: http://www.excelforum.com/showthread.php?threadid=56166