How do I do a TODAY() Function within a Nested IF AND Function

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
 
S

Simon Lloyd

Can you supply your whole formula?, the formula you give works fine but
only looks to display the contents of one cell not "calculate" anything.

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


--
Simon Lloyd

Regards,
Simon Lloyd
'Excel Chat' (http://www.thecodecage.com/forumz/chat.php)
 
A

Andrew Taylor

Are the dates in column BV genuine dates (i.e. numeric
values formatted as dates) or text? If the latter then try
using
=IF(AND($C13=$B$13,DATEVALUE($BV13)>=TODAY()),$CJ13,"")

(though generally I dislike DATEVALUE as it is sensitive to
changes in regional settings)

Andrew
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top