Filtering data dependent on the date

Hi

I have a spreadsheet showing a number of jobs with numerous columns for individual bits of data regarding the jobs.

Two of these columns show a strat date and an end date for the jobs.

What I require is a seperate worksheet that will show the rows that have the formula =Today() be equal to or in between the start and end dates.

I've been trying for ages now and have a mental block. Can anyone please help. Any help would be greatly appreciated

Hello Neil Pattison:

I’m assuming you want today’s date to be displayed on a separate sheet if today’s date falls between the start and end date.

Assuming start date and end date are on Sheet1: start date column A, end date column B.

Paste this on Sheet2, and copy down.

=IF(AND(TODAY()<=Sheet1!B1,TODAY()>=Sheet1!A1),TODAY(),"")


Matt