Need to display a value only based on a date.

faye_m_cook 

Is this possible?

I'm sure it's possible--although that is a leap of faith because I'm not exactly clear on what "it" is.

Your description, absent a visible or actual example of the workbook in question, is a bit too abstract to know precisely what you mean. I suspect that may be why, after 40+ views you've gotten no response.

So I invite you to post a copy of the actual workbook, or--if the actual contains confidential data--a reasonable enough mockup devoid of the names of products/customers, etc. Post it on this forum using drop and drag below the message window, or if that doesn't work, use OneDrive or GoogleDrive and paste a link here that grants access.