I am working hard to get my head around formulas and have managed to get the correct return with the below formula, if greater than 14 days then return "Yes", if less than 14 days then return no. Where i am struggling is i also want to return "Yes" if the cell is blank.

current formula:



I am trying to count the total in a range on another sheet if entries fall within a certain date range (30 days) and are a specific name "Missed Hours"

I have the following formula but cant get it to work: 

=SUMIFS({Help Desk Range 1}, <=TODAY(), {Help Desk Range 1}, >=TODAY(-30), {Help Desk