Re: OT: Excel Help
Wherever you'd want to put it that isn't going to have some other data. The most likely spot would be C2.
And the formula would be
=IF(B2="",IF(TODAY()-A2>180,"yes","no"),"no")
Or are you wanting it to list the actual number of months instead of yes or no that it's over 6 months?
__________________
I used to be somebody but now I am somebody else
Who I'll be tomorrow is anybody's guess
|