=IF(ISBLANK(Dec!E2),YTD!F12,(IF(ISERROR(SUM(((F32)/(DAYS360(DATE(2004,12,31),S1,FALSE)))*(360))*(F13)),"",(SUM((F32)/(DAYS360(DATE(2004,12,31),S1,FALSE))))*(360))*(F13)))

The above formula calculates the "projected" year end sales gross. How do I
get the formula to automatically change the start date based on the actual
hire date of the employee if they are hired some time after the first of the
year?