Date Not Processing as Date

[mkron]

I am working on writing a macro to prioritize work. I currently have it order by due date. I am trying to add a score to each order using:

=IFS([DUE DATE]< TODAY(), 10+DAYS(TODAY(), [DUE DATE])*1, [DUE DATE] = TODAY(), 8, [DUE DATE] = TODAY()+1, 6, [DUE DATE] > TODAY()+1, 0)+[DAYS AGED]

If it is late it get s score of 10, due today an 8, and due tomorrow a 6 and then the amount of time is has aged is added. Late orders get an extra point for the amount of days it is late.

The dates are formatted as General and come in looking like this "05/30/2017" even if I change the format to Short/Long Date the equation doesn't update. I have to manually remove the first zero to make it 5/30/2017. I have tried making a column using =mid(A##, 2, len(##)). however that has not worked either.

Any help or tips would greatly appreciated!
Thanks!
-MK

 

[Jonmo1]

Try copying a blank cell
Then highlighting the Due Date column
Right click - Paste Special - Values - Add - OK.

 

[mkron]

Worked wonderfully, thank you!

 

[Jonmo1]

You're welcome.