Date Format

[Rajkumar]

Hi,

Frequently i am downloading some datas from our ERP,in which the date'
are downloaded as in this style.

25.11.2003

i am not sure this in what format.But when i use the formulae

=days360(a1,b1,true) to find the difference between 2 dates,excel i
giving error msg as #VALUE!

pls help me to sort out this issue.

Rajkuma

 

[buddie]

Hi there,
check that the cell is not in text format,
try 28/11/03 to test if there is any change.
buddi

 

[Rajkumar]

the cell is showing in General format.

And i need to convert 2 to 3 columnns of dates to date format.

the problem is, i need to convert these data to date format.And the
apply the function.

i tried Format cells->date, but no use.

Pls help.
Rajkuma

 

[buddie]

Try this.........
Highlight all the cells that have the dates in the format 28.11.2003
that you want to use then go to the replace function under the edi
menu.
Do a replace all "." with "/" or "-". You should find that your date
will be recognised by the formula.
It just does not like "." , does not recognise that as a date.
But pls do a backup or sample one cell first.
regards
buddi

 

[Ron Rosenfeld]

Hi,

Frequently i am downloading some datas from our ERP,in which the date's
are downloaded as in this style.

25.11.2003

i am not sure this in what format.But when i use the formulae

=days360(a1,b1,true) to find the difference between 2 dates,excel is
giving error msg as #VALUE!

pls help me to sort out this issue.

Rajkumar

I don't know what your regional settings are, but the following should work
regardless:

1. Select the column in which the dates are listed.
2. Data/Text to Columns
3. Next
4. Next
5. Column Data Format: Date: DMY
6. Finish


--ron