Hi,
I am able to get the difference between two dates when dates are in mm/dd/yyyy but not when format as dd/mm/yyyy.
How to find difference between two dates format is DD/MM/YYYY.either formula or VBA.
At the same how can I change my Excel timezone currently for all showing as mm/dd/yyyy to dd/mm/yyyy. (Not by format cells Ctrl+1).
Thanks in advance .
I am able to get the difference between two dates when dates are in mm/dd/yyyy but not when format as dd/mm/yyyy.
How to find difference between two dates format is DD/MM/YYYY.either formula or VBA.
At the same how can I change my Excel timezone currently for all showing as mm/dd/yyyy to dd/mm/yyyy. (Not by format cells Ctrl+1).
Thanks in advance .