It does not matter the way the date is formatted as. Whether it is dd/mm/yyyy or mm/dd/yyyy the answer will still be the same. Please attach a sample workbook with what you have input so I can take a look.