| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare date against multiple dates
you could try and compare the "text" value of the month of the date, eg jan,feb,mar,apr. Make a lookup table where jan=1 feb=2 mar=3 so check if the number returned from the lookup table is <, = or the number returned when AP6 is offered to the lookup table -- robert111 ------------------------------------------------------------------------ robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 View this thread: http://www.excelforum.com/showthread...hreadid=536392 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate Start Dates based on Need-By Date? | Excel Worksheet Functions | |||
| compare date to column data | Excel Worksheet Functions | |||
| compare date ranges to set up eq | Excel Worksheet Functions | |||
| How do I retrieve a date in a column of dates which > my criteria | Excel Worksheet Functions | |||
| Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
Threaded Mode
