Re: Date format in Excel
- To: mathgroup at smc.vnet.net
- Subject: [mg48468] Re: [mg48395] Date format in Excel
- From: Omega Consulting <info at omegaconsultinggroup.com>
- Date: Mon, 31 May 2004 00:14:03 -0400 (EDT)
- References: <200405280450.AAA18383@smc.vnet.net>
- Sender: owner-wri-mathgroup at wolfram.com
On May 27, 2004, at 11:50 PM, trousseauc at post.ch wrote:
> Hello,
>
> I am in Excel and work with Mathematica. I want to use a Excel Cell
> with
> the format "date" so that I can call it und use it in another
> mathematica function. But the format convert automatically to a
> standart
> format so that i can't use the content of the cell in a function who
> need a date.
> Example:
> - Cell M11: 25.05.2004
> - =Math("Names";M11) gives me Names[38132]
> Do you no if I can use the content of Cell M11 as a sting or make a
> List
> of it ({25,05,2004}}?
> I hope you can help me or guide me to a user group.
> Thank you, have a nice day,
>
> Carole Trousseau
I don't know why you'd use Names on such a creature, but you can
convert to Mathematica date format with the following formula:
ToDate[(38132 + 2)*(60*60*24)]
{2004,5,29,0,0,0.}
A little bit of post-processing with ToString and you should be able to
create whatever string you like from that.
----------------------------------------------
Omega Consulting
The final answer to your Mathematica needs.
http://omegaconsultinggroup.com
- References:
- Date format in Excel
- From: trousseauc@post.ch
- Date format in Excel