CODEWITHSUNDEEP
excelexcel-formula
Andrei Ion
Andrei Ion

Reputation: 1827

How to subtract dates in Excel with different date formats?

I want to subtract 2 dates in Excel but the problem is they have different date formats. So... my first date is something like this 18.09.2011 (DD.MM.YYYY) and the second one is something like 9/15/2011 (MM/DD/YYYY). So how can I subtract these two dates? Because DAY(cell of date one) - DAY (cell of date 2) won't work. Thanks!

Upvotes: 2

Views: 10004

Answers (1)

MikeD
MikeD

Reputation: 8941

If your dates are really entered as dates you can use them in any kind of calculation, as a date really is stored as a numeric value. Displaying one date in "MM/DD/YY" and the other one in "DD.MM.YYYY" doesn't make a difference. Try to format the cells as "General". Does the display change to a number (e.g. 40801 for today) you're fine. If your dates are entered as strings you may want to convert them into dates first - see this post

Upvotes: 3

Related Questions