I have a simple date formula that I want to present "yes" in a cell when another cells date is less then or equal to "Today". I just can't figure out how to make it show my result cell as blank if my date cell is blank?
here is my formula....
=IF(G8 <= TODAY(), "YES", "")
Last edited by kerndogg; 12-09-2009 at 02:16 PM. Reason: Solved
A few routes one would be
=IF(AND(G8>0,G8<=TODAY()),"YES","")
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
perfect, thanks. I had it close on a couple tries but didn't quite have it right. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks