Forum Discussion
trying to use datedif function
hI Sergei thanks, that worked for the fields that had both a hire date and a term date, but what about the ones that produced 0 due to having "Active" as text in the term date field or "Not hired" in the hire date field? SergeiBaklan
I didn't find "Active" first time, my guess was it shall be TODAY(). With that it could be
Perhaps you may give possible combinations of dates and texts, it's bit hard to make a guess what VLOOKUP():s shall return.
That is my data sheet, I need function for termination date that will show when they were terminated but if the field is blank due to no termination yet I need it to say todays date so that I can subtract term date and hire date to get tenure column to have the date difference
There are different VLOOKUP formulas in your first post and on screenshot, not sure which one you use. Anyway, let assume in hire date column cells could be two variants of values - text or date. Actually the same is term date column, the only difference that could be here Term Date or TODAY() or text.
Plus for some cells we have Jan 00, 1900, or zero - VLOOKUP() returns value of the blank cell.
IMHO, formula works for all such combinations