compare dates
 

=IF(('Input Sheet'!$B$80),'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$80),D8<'Input Sheet'!B6)),'Input Sheet'!$B$8,0)

Any thoughts...

compare dates
 

Just lose some of your brackets:

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

Hope this helps.

Pete

On Apr 27, 1:10 am, Thea wrote:
=IF(('Input Sheet'!$B$80),'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$80),D8<'Input Sheet'!B6)),'Input Sheet'!$B$8,0)

Any thoughts...