J
Jennifer E
Hi,
I'm trying to create a nested IF AND function. The difficulty I'm having is
getting the function to calculate/include just the rows that have a date that
is later than or equal to today. The "today" date would move as the file is
opened and updated. The difficulty I'm having with it, though, is that it's
calculating the rows that are blank or those that a date has been provided,
but not just the date which is today or later.
My current formula looks like:
=IF(AND($C13=$B$13,$BV13>=TODAY()),$CJ13,"")
Thanks,
Jennifer
I'm trying to create a nested IF AND function. The difficulty I'm having is
getting the function to calculate/include just the rows that have a date that
is later than or equal to today. The "today" date would move as the file is
opened and updated. The difficulty I'm having with it, though, is that it's
calculating the rows that are blank or those that a date has been provided,
but not just the date which is today or later.
My current formula looks like:
=IF(AND($C13=$B$13,$BV13>=TODAY()),$CJ13,"")
Thanks,
Jennifer