Hi all,
I am a basic user, but I need to put in a formula for conditional formatting that returns a true value if today's date is within the 3 months prior to a given date in a cell on the spreadsheet, or if the date in that cell has been passed.
Any help would be greatly appreciated.
for a starting point see: http://www.contextures.com/xlCondFormat03.html#Expiry
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks