=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...