Posted to microsoft.public.excel.misc

Wanna Learn Wanna Learn is offline

external usenet poster

Posts: 318

format dates enigma

Hello I receive a monthly report that has dates that I need deciphered.
Column title is "week ending" the date is 08-10-26 , this means week
ending October 26 2008 . the next colum is "Day" and it has a 1 .(could be
any number from 1 to 5 . 1 being Monday, 2 = Tuesday 3 = Wednesday .
SO 08-10-26 1 = Mon 10/20/08 .
Is there a formula to do this. thanks in advance

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
CONVERT DATES FROM EUROPEAN FORMAT TO US FORMAT	les8	New Users to Excel	8	August 8th 06 05:48 PM
Format text 'dates' to real dates	Jacy	Excel Worksheet Functions	4	July 24th 06 02:10 AM
Format dates	steven	Excel Discussion (Misc queries)	4	January 19th 06 12:44 PM
keeping dates in UK format	jarvo	Excel Discussion (Misc queries)	7	August 17th 05 04:03 PM
the dates on cell format make different dates.	date formats morph the dates/chang case	New Users to Excel	6	April 18th 05 02:41 AM

All times are GMT +1. The time now is 02:17 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us