Date format???

  • Thread starter Thread starter Sven
  • Start date Start date
S

Sven

For my work I am making a file to follow up thinks.
But recently I found a way to get information from our system to excel.
Now the problem is, that the date form is wrong.

Excel takes the dd for jj & jj for mm & mm for dd.
I can put them in correct order, bij changing in cell properties - changed
to the correct view form.

But when I want to work more with the date to link it to week or month's it
wont work becaus for excel the mm or dd or jj doesn't change. I just
changed the order to look right.

Can someone help me?

Gr sven
 
This part is unclear:
Excel takes the dd for jj & jj for mm & mm for dd.
I can put them in correct order, bij changing in cell properties - changed
to the correct view form.
Click to expand...

If cell A1 has the day, B1 the month and C1 the year, then you can get a
real date with the formula =DATE(C1,B1,A1) use this order no matter how you
like to view dates.
If the year (C1) has only two digits use =DATE(C1+2000,B1,A1)

Now format the cell as a date (Format|Cells|Date and select the way you like
to see dates)
Hope this is relevant
best wishes
 
Back
Top