compare dates

T

Thea

=IF(('Input Sheet'!$B$8>0),'Input Sheet'!$B$8,0)
I'm currently using the formula above to confirm there is data to be copied,
but I would also like to make sure the date governing a column is less than
or equal to the departure date which lives on a data entry page call Input
Sheet...

I tried the following where D8 is a calculated date field and 'Input
Sheet'!B6 is an entered date.

=IF(AND(('Input Sheet'!$B$8>0),D8<'Input Sheet'!B6)),'Input Sheet'!$B$8,0)

Any thoughts...
 
P

Pete_UK

Just lose some of your brackets:

=IF(AND('Input Sheet'!$B$8>0,D8<'Input Sheet'!B6),'Input Sheet'!$B
$8,0)

Hope this helps.

Pete
 
Top