Posted to microsoft.public.excel.misc

external usenet poster

Posts: 12

converting dates from file

Hi,

I am receiving dates in an excel file that appear to be in format m-dd-
yyyy format. When I execute the formulas day() and month() they get
them the wrong way round ie the month returns the day and vice versa.

Can someone tell me how I get around this problem and why its
occuring?

regards
Colm.

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
converting Dates	torpido	Excel Worksheet Functions	2	January 27th 15 10:24 AM
Converting Dates	wutzke	Excel Programming	3	March 16th 08 09:34 PM
Converting Julian Dates to regular dates	CDTucson	Excel Worksheet Functions	2	June 7th 07 04:20 AM
Converting Text dates into dates	EAB1977	Excel Programming	2	January 20th 06 04:20 PM
Converting dates	Ana	New Users to Excel	6	September 9th 05 07:51 AM

All times are GMT +1. The time now is 03:35 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us