| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare date against multiple dates | Excel Discussion (Misc queries) | |||
| Compare two dates and if they are equal | Excel Discussion (Misc queries) | |||
| how do I compare two dates? | Excel Worksheet Functions | |||
| conditional formatting - compare 2 dates | Excel Discussion (Misc queries) | |||
| Compare range of dates and sum... | Excel Discussion (Misc queries) | |||
Threaded Mode
