Excel 2007 : REALLY need your help with a function -- days360 network days format

[cen03]

So I am trying to calculate the number of days between two dates that are in dd/mm/yyyy form.
Now I know that there are: Days360 and NetworkDays functions HOWEVER they work on mm/dd/yyyy forms

I have over 3000 inputs that need to be done and I cannot change each and every date to a mm/dd/yyyy form so is there any way that either there is a formula that works on dd/mm/yyyy formats OR to change the dd/mm/yyyy automatically into mm/dd/yyyy when I copy paste it into the excel sheet so that the functions work??

Please any help is appreciated thanks so much in advance

[arlu1201]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.