End date in formula

[yaelcohen]

Hello

Thanks for any help

There is a table of directors while Ron is still director today.

NameStart dateEnd date 31/12/200231/12/200331/12/2004
Yehuda10/07/200212/09/2006 1 1 1
Ron31/03/2004

The formula I use is mentioned in the file. How can I add the date of today or any specific date (as the date of the report) in order to get Ron in this table also.

Thanks a lot again for the help

Yael

 

[Ramesh]

=IF(AND(J$2>=$C4,J$2<=IF(LEN($D4)=0,TODAY(),$D4)),1,0)

Check out this formula..see if that helps!!

 

[oldchippy]

This should work

=IF(AND(G$2>=$C3,G$2<=IF(LEN($D3)=0,TODAY(),$D3)),1,0)

Copy across and down

Alternative

=IF(AND(G$2>=$C3,G$2<=IF($D3="",TODAY(),$D3)),1,0)

 

[yaelcohen]

=IF(AND(J$2>=$C4,J$2<=IF(LEN($D4)=0,TODAY(),$D4)),1,0)

Check out this formula..see if that helps!!

Thanks, it works!