Donate SIGN UP
Home > Technology > Computers > Ms Excel 2007: If ("cw34";b1="18.08";"")

Ms Excel 2007: If ("cw34";b1="18.08";"")

Avatar Image
gl556tr | 16:16 Tue 19th Aug 2014 | Computers
1 Answers
Hello.__I have a file containing spreadsheets that are named for each successive week of the year, starting with "CW01"..."CW52". _>__Is there a means whereby one can insert the week-beginning date (here: 18.08), depending on the sheet-number (here: CW34) automatically into a specific cell (here: B1)? Thank you.
prev Click + Drag?
  
next What's Happened To My Text In Ms Word
Gravatar

Answers

Only 1 answerrss feed

Best Answer

No best answer has yet been selected by gl556tr. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Avatar Image Old_Geezer
No expert but I'd imaging you could look it up and take the date from a hidden data table.
17:10 Tue 19th Aug 2014

Only 1 answerrss feed

Do you know the answer?

Ms Excel 2007: If ("cw34";b1="18.08";"")

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.