Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing 3 dates
Hi
I need a function that will determine whether a date falls between two other dates. If the date does fall within the time band, the function will return a "yes", if it doesn't it will return a "no" Thanks Steve |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing 3 dates
Hi Steve,
If the earliest date is in A1, the latest date in C1 and the test date is in B1, and all dates are stored as values, you could use something like: =IF(AND(B1A1,B1<C1),"Yes","No") This tests whether B1 is *between* A1 and C1. If you want to include A1 and C1 as valid dates, use something like: =IF(OR(B1<A1,B1C1),"No","Yes") Cheers "Steve" wrote in message ... Hi I need a function that will determine whether a date falls between two other dates. If the date does fall within the time band, the function will return a "yes", if it doesn't it will return a "no" Thanks Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Comparing dates | Excel Worksheet Functions | |||
return array result in cell based on comparing dates | Excel Worksheet Functions | |||
Comparing Dates using Greater Than and Less than | Excel Discussion (Misc queries) | |||
Comparing dates in an IF function | Excel Worksheet Functions |