Date format problem from an BI query
I have to different dates in 2 colums, this is a BI file and exported to excel, but now it seems that excel is not seeing this dates a valid date format? I uploaded the file can someone please assist. Cause if want to use formula to count the days in between and excel needs to see this a a proper date format. want to use formula =datedif(x1,y1,"D")
please help
Select a column of dates, Data > Text to Columns, click Next twice, tick Date, select MDY then click Finish. Repeat for the other column.
d1and drag down en to the left
=+A1*1
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Nope none of the two solutions works?
Worked for me with your sample file.
Hi Thalassa, thanks for the feedback, could you count the day after you changed it with the folmula datedif? still give me #value error
Some dates in column A are greater than those in column B and vice versa. You would need a formula like
=IF(B1>A1,B1-A1,A1-B1)
Thalassa, thanks just did it wrong!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks