I need an updated excel formula

wrt1mea
wrt1mea used Ask the Experts™
on
I need to update the following formula to work ONLY if there is a value in Cell H2 (which is a date field) that is greater than 0. I was using the greater than 0 approach due to the date field being a number.

=IF(G2="","",IF(H2="",TODAY(),H2)-G2)
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
Crap...forgot to include this one too...

=IF(G2="","",NETWORKDAYS(G2,IF(H2="",TODAY(),H2)))
Excel VBA Developer
Top Expert 2014
Commented:
=IF(G2="","",IF(H2="",TODAY(),H2)-G2)
becomes
=IF(G2="","",IF(H2>0,H2,TODAY())-G2)


=IF(G2="","",NETWORKDAYS(G2,IF(H2="",TODAY(),H2)))
becomes
=IF(G2="","",NETWORKDAYS(G2,IF(H2>0,H2,TODAY())))

Author

Commented:
Works Perfectly! Thank you very much!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial