Help with Workday Formula

[snaplink22]

Hello,

I have the following formula: =IF(D3="","",WORKDAY(D3,F3-1)). This allows me to determine how many days out from the Start Date the Estimated Completion Date should be, however, if the Number of Hours column is a number 1 or less I want the value in Column G to return the same date as what is listed in Column D. This would show anything up to and less than a full days work would be completed the same day.

 

[MARK858]

You could just nest another IF...
=IF(D3="","",IF(E3<=1,D3,WORKDAY(D3,F3-1)))

 

[snaplink22]

You could just nest another IF...
=IF(D3="","",IF(E3<=1,D3,WORKDAY(D3,F3-1)))

Thanks for your help Mark. I found that this formula will change the date to the next day if 8.01 or more is entered, while keeping it to the same date if 8.00 or less is entered:
=IF(D3="","",IF(E3<=8,D3,WORKDAY(D3,F3)))

 

[MARK858]

Yes it would. What is your question?

 

[snaplink22]

Yes it would. What is your question?

No question, just thanking you for your help and that the modified formula seemed to work for me, however, now that I'm playing with it I'm encountering an interested problem. When I enter in 8 hours or less the date stays the same, when I entered in 8.01 to 15.99 the date goes 1 day out (as it should), but when I input 16 the date goes three days out instead of two.

 

[snaplink22]

No question, just thanking you for your help and that the modified formula seemed to work for me, however, now that I'm playing with it I'm encountering an interested problem. When I enter in 8 hours or less the date stays the same, when I entered in 8.01 to 15.99 the date goes 1 day out (as it should), but when I input 16 the date goes three days out instead of two.

View attachment 14201

Hmmm, so if I change the formula in cell F3 to: =ROUNDUP(IF(E3="","",(E3/8)),0) that works with the above formula in cell G3, but now I get a #VALUE! error in cell F3 if no data is inputted into cell E3.

 

[MARK858]

Can you not move the ROUNDUP?

=IF(E3="","",ROUNDUP(E3/8,0))

 

[snaplink22]

Can you not move the ROUNDUP?

=IF(E3="","",ROUNDUP(E3/8,0))

Ugh, I kept putting the 0 on the inside of the last parenthesis and not E3/8,0. Thanks Mark!

 

[MARK858]

You're welcome.