date reminders: =IF(K5<=TODAY(), A5, " ")

B

benbulloch

I am fairly inexperienced with Excel so I'll outline my problem, and m
solution so far. I essentially want an automatic task list based upo
whether the date has arrived (or past) to do the task.

I have 100 data rows (tasks) with a Date as one column. If the Date i
the column is Today or after Today then I want the name of that ro
returned.

So far I have come up with:

=IF(K5<=TODAY(), A5, " ")
where k5 is the row's Date and A5 is the row's name.

This works but returns a bunch of blank rows when the IF is false. Ho
can I either do this more efficiently or remove the blank rows from th
report section?

Thanks in advance.
Ben Bulloc
 

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

Similar Threads

Change Color of Cell based on Date and today's date. 1
Color a cell based on column date and row content 2
Conditional Formatting - Cannot get it to work, please help 1
Time lines, Gantt charts and auto-populating cells: possible? 0
Minimum Date Greater than Today() 6
Populate Cell with another cell, but only if the date equals today 4
Sum a range of cells starting from an offset date list from TODAY() 3
Add Cells in a row depending on Date 2

Top