1

I need to calculate days between today and the 'Last day to offer' and have Excel return a 0 if today is the last day to offer or if the date has passed; otherwise it should return the number of days left to offer (taking into account weekends and holidays).

I currently have

=NETWORKDAYS(TODAY(),E20,Holiday)

as the formula to calculate the 'Days left to offer', but this (obviously) does not return a zero when appropriate.

Improve this question

1 Answer 1

Reset to default
1

Maybe you could use an IF?

=IF(NETWORKDAYS(TODAY(),E20,Holiday)<=1, 0, NETWORKDAYS(TODAY(),E20,Holiday))
Improve this answer
3
  • I must have typed something wrong when I attempted that formula, because yours worked but mine didn't LOL. Thank you!
    – Donna
    Jan 13, 2014 at 16:24
  • @Donna Haha, that happens to the best of us :) You're welcome!
    – Jerry
    Jan 13, 2014 at 16:26
  • Stupid parenthesis!! LOL
    – Donna
    Jan 13, 2014 at 16:28

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .