| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Show blank when today() is within a certain date range
I have a date in cell C90.
I need a formula in K90 that keeps the cell blank when the month of today() does not exceed 1 full month after the month in C90. Eg, if the date in C90 is 3rd Jan 07 and the month of today() is up to and including Feb, I want the cell to be blank. As soon as the month of today() = March, then I want a figure to be shown, i.e. I want to be able to perform my getpivotdata function. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MAX figure within a date range as a function of today()'s date | Excel Worksheet Functions | |||
| SUMIF within date range as a function of today()'s date | Excel Worksheet Functions | |||
| Show a date based on today | Excel Worksheet Functions | |||
| Show a date based on today | Excel Worksheet Functions | |||
| Show a date based on today | Excel Worksheet Functions | |||
Threaded Mode
