Surely.... But we need a sample workbook with expected result.

Please mention your system Date Setting which you can find in Regional Date/Time Setting under Control Panel