Things not clarified ,,

More than one rows per date

how spend date was calculated

how late and half date was updTED

etc

GIVE PROPER EXPLANATION ON HOW THE DATA RESIDES , AND WHAT WAS THE BUSINESS RULES TO FRAME THE OUTPUT ..THAT SAVES A TONS OF TIME

Your just giving data and output