What am i doing wrong?
=IF(M18="","",(TODAY()<M18,"current","expired"))
it works without the m18="","", ...just don't want expire to show up in a cell where the adjacent has no date.
any help is appreciated!
thanks!
What am i doing wrong?
=IF(M18="","",(TODAY()<M18,"current","expired"))
it works without the m18="","", ...just don't want expire to show up in a cell where the adjacent has no date.
any help is appreciated!
thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks