Mike you are awesome! This is what I have been trying to do! Now if there was only a way to subtract hours used from the cells in B25 through B49 as that date comes up instead of all at once this would be perfect, but it will do what I need it to do.Again thank you, I'm going to go to bed because I'm getting cross eyed looking at spreadsheets but I'll finish this tomorrow and make it all pretty. Again thank you!