Hi,
I know that calculating the difference between two dates is doable in excel using the subtraction or "DATEDIF" function if the date format is month/day/year.
However, is it possible to calculate the difference between dates if the format is day/month/year? I tried it, but the result is (#Value!) even if I changed the format of the date cells to be in the format of day/month/year.
Any Solution for this?
I am using Excel 2013
I know that calculating the difference between two dates is doable in excel using the subtraction or "DATEDIF" function if the date format is month/day/year.
However, is it possible to calculate the difference between dates if the format is day/month/year? I tried it, but the result is (#Value!) even if I changed the format of the date cells to be in the format of day/month/year.
Any Solution for this?
I am using Excel 2013