Hello: I am trying to write a formula to calculate per diem based on the number of days that someone worked AND add an additional day if the person worked 5 or 6 days. Right now I have the following to just count the number of days they have worked:
=COUNTIF(R14:X14,"<>0>)
This returns the result that I am wanting EXCEPT that I need it to add an additional day if they worked 5 days for a total of 6 or if they worked 6 days then a total of 7. HELP! I am at a loss!
TIA
=COUNTIF(R14:X14,"<>0>)
This returns the result that I am wanting EXCEPT that I need it to add an additional day if they worked 5 days for a total of 6 or if they worked 6 days then a total of 7. HELP! I am at a loss!
TIA