Hi,
I'm trying to create an IF function with multiple conditions in Excel 2010 to be used as a report filer in a PivotTable.
My workbook has three columns - Status, Status Change Date and Award Date. I would like to end up with a formula that returns TRUE/FALSE based on the conditions of the table below:
The formula below returns TRUE if the date in B2 is within the current year and month. Is it possible to extend the formula with the conditions of the table above?
I have uploaded a sampe file here.
I'm trying to create an IF function with multiple conditions in Excel 2010 to be used as a report filer in a PivotTable.
My workbook has three columns - Status, Status Change Date and Award Date. I would like to end up with a formula that returns TRUE/FALSE based on the conditions of the table below:
The formula below returns TRUE if the date in B2 is within the current year and month. Is it possible to extend the formula with the conditions of the table above?
Code:
=IF(AND(MONTH(NOW())=MONTH(B2);YEAR(NOW())=YEAR(B2));TRUE;FALSE)I have uploaded a sampe file here.
