Hello everyone!
I am sure that this has been covered before as i know I have seen it in the past, I just can't find the right combination of words to search for.
I am trying to create a column of numbers that are made up of the year,month,day. This is easy with dates prior to 1900 however with dates after 1900 you need an add-in Xdate. I downloaded this addin but it doesn't quite work.
the result of =xdatemonth(03) is 3 and not 03. I need it to keep that 0. Same with the day ie 01 should stay 01 and not revert to 1.
So I was going to use an offset (i believe it is an offset) to parse out my current date into the that format.
Example.
date is 03/31/1887 so the new column would contian 18870331. ie. first the characters 7-10 then characters 1-2, then characters 4-5.
I tried to do a simple find and replace and remove the / but my dates are formatted in 03/31/1887 and they don't read as dates so I can't format them as 1887/03/31
Any help is greatly appreciated.
Hayden
I am sure that this has been covered before as i know I have seen it in the past, I just can't find the right combination of words to search for.
I am trying to create a column of numbers that are made up of the year,month,day. This is easy with dates prior to 1900 however with dates after 1900 you need an add-in Xdate. I downloaded this addin but it doesn't quite work.
the result of =xdatemonth(03) is 3 and not 03. I need it to keep that 0. Same with the day ie 01 should stay 01 and not revert to 1.
So I was going to use an offset (i believe it is an offset) to parse out my current date into the that format.
Example.
date is 03/31/1887 so the new column would contian 18870331. ie. first the characters 7-10 then characters 1-2, then characters 4-5.
I tried to do a simple find and replace and remove the / but my dates are formatted in 03/31/1887 and they don't read as dates so I can't format them as 1887/03/31
Any help is greatly appreciated.
Hayden