Formula problem

B

Bill R

=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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AND/OR FUNCTIONS 2
First part of "IF" function returns false even if true. ?? 4
Trying to pull date from field getting error. 5
copy worksheet to another worksheet 2
Number of days 2
Day Number For 365 Day Year 5
Help with an IF Formula 5
How to write XIRR formula on excel using different Year basis than 365. 5

Top