Date Question
I tried using this function, but I keep on getting a wierd result.
For example, if the date is 9/6/2005 in a1, in b1 I put =month(a1) and I get
1/9/1900 as my answer.
Am I doing something wrong?
"metaltecks" wrote:
Can these functions work if the format in column A1 is 04/04/05?
"metaltecks" wrote:
In my spreadsheet I have a date column, ex 4/14/1998.
I need to parse out the date, so I will have one column as the month, day,
and year.
In otherwords, i will a separate column for each of these numbers.
How do I do that without manually doing it?
|