EXCEL Changing date format in high frequency data

naeemjan · March 27th, 2013, 8:11 am

Hi, I have high frequency 15 mint interval data which have date and time together in one column in Excel . I need towrite only dates without time. I try to do it but as I drag down the date it does not match with the original dates because of 15 mint interval high frequency data. What should I do?

tags · March 27th, 2013, 8:22 am

Let's assume the date you are dealing with is in cell A1.try:1) =INT(A1)or2) =DATE(YEAR(A1),MONTH(A1),DAY(A1))Does that get what you want?

naeemjan · March 27th, 2013, 9:47 am

Thank you for your reply, Actually the second formula works But have given the same constant dates.Actually I have one year exchange rate data 15 mint interval not daily. So there are about 96 observation in one dayso the date should remain constant until 96 observation and similar procedure for remaining data.

tags · March 27th, 2013, 12:39 pm

Can you upload your spreadsheet so that people can work this out in 'hard' mode?

acastaldo · March 27th, 2013, 3:40 pm

In Excel dates/times are expressed in days and fractions thereof.If you wish to discard the hours and minutes and just be left with days, then Edouard's =INT(A1) works. If not then please explain what you wish to do.

naeemjan · March 27th, 2013, 7:05 pm

Now Its working, thanks to all who reply!