compare dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=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...
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to get the number of days an item was opened from the today's date. 14
Excel Import Comments 3
my first excel experience (share portfolio) 2
Reserved dates 3
Update cell value based on name and specific date 1
Excel Macro to copy a row to another sheet based on date 0
Required solution for an vlookup exception. 0
Populate Text based on conditions 1

Back
Top