date column not working

Dear All,

I changed my pc and my formula stopped working on all my new excel files, everytime i paste my new date the formula stops
however it is working fine on all old files, i tired to change date format in A, and copying new data into old file but the formula won't work

i hope if you can check both attached to see what is missing, and thanks for your usual help

The formula, as defined, works correctly: if "fails" i.e returns blank, either because successive "Dest Plat#" are different OR where they are the same, the month is the same.

In your "Working" file none of the above occur so it works "correctly": copy your working data to the new PC.

Originally Posted by JohnTopley

The formula, as defined, works correctly: if "fails" i.e returns blank, either because successive "Dest Plat#" are different OR where they are the same, the month is the same.

In your "Working" file none of the above occur so it works "correctly": copy your working data to the new PC.

Yes, my new file has the same month could this be a reason, do i need to modify the formula ?

I only need to subtract the kilometers of each vehicle per month

thanks for your help

Firstly try restarting your pc then copy data into your new PC