Forum Discussion
to ADD or REPLACE?
I'm trying to add another function to an existing step. Currently, I have a properly functioning formula of: =IF(ISBLANK($H7), "", TODAY()-$H7) which, when date column H is blank, so also, is da...
correction on ultimate goal:
# of days worked between G or I dates & S
Ok, so.. this works I think:
=IF(ISBLANK($G2),"",IF(ISBLANK(S2),IF(ISNUMBER(G2),TODAY()-$G2,IF(G2="Anticipated Vacancy",0,TODAY()-I2)),S2-G2))
But its not very robust. As long as you stick to the 'rules' as outlined in your last post this should do what you want.
I'm pretty sure there is a neater way of doing this, but right now I cant think of it.