Dates showing up as numbers when using =IF formula. Need Formula for multiple data

Attached is the workbook I am working on.

IF go to any of the G1-G6 Worksheets the dates show up as regular numbers when on the original (Unit worksheet) they are dates

I have formatted them as dates and it still does nothing. If the dates are working I have conditional formatting set on the G2 and the Master that should let me know if certain things are in Column J or if certain dates are in Column G



Also on the Master worksheet I am looking at column J

I would like that column to look into all of the G worksheets and see if they match the values in Column A and if they do then I want the G worksheets Column J to be copied to the Masters Column J.... Kind of like what is in the G1 worksheet on any of the cells between A5 and J500 only multiple worksheets.


On the STATS worksheet if you have any suggestions on how to simplify my formulas to do the exact same thing they are doing that would be awesome.




In fact if you have ANY suggestions on how to make this a much smoother workbook I would be willing to learn and try it....Work book.xlsx

you are concatenating alot of cells together
=IF(UNIT!E459="WPER",UNIT!I459,"")&IF(UNIT!E459="WINS",UNIT!I459,"")&IF(UNIT!E459="OPS0",UNIT!I459,"")&IF(UNIT!E459="WADJ",UNIT!I459,"")&IF(UNIT!E459="CPLN",UNIT!I459,"")

And they are all using Unit!I459

so that becomes a text rather than a number

so you could add
=VALUE( )
to the formula

=VALUE(IF(UNIT!E459="WPER",UNIT!I459,"")&IF(UNIT!E459="WINS",UNIT!I459,"")&IF(UNIT!E459="OPS0",UNIT!I459,"")&IF(UNIT!E459="WADJ",UNIT!I459,"")&IF(UNIT!E459="CPLN",UNIT!I459,""))
to change the text back to a NUMBER

OR

=IF(OR(UNIT!E459="WPER",UNIT!E459="WINS", UNIT!E459="OPS0", UNIT!E459="WADJ", UNIT!E459="CPLN"), UNIT!I459, "")

And probably simplify with using an Array
OR(UNIT!E459= {"WPER","WINS","OPS0","WADJ",CPLN"}) - but cannot remember the exact syntax - so i will look up or another member will help