Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
check if a a date is in a specified daterange
I need to check if a date is within a specified date range, then C4 may
return true or false C D E F 2 12-04-2008 01-03-2008 01-05-2008 3 4 if C2 is between E2 and F2 = true else = false Is there someone who can help me to make the code function that can handle this small matter:) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
check if a a date is in a specified daterange
=AND((A2E2),(A2<F2))
will give you TRUE or FALSE... You can put an IF around it =IF(AND((A2E2),(A2<F2)),"Value if TRUE","Value if FALSE") "H. Nissen" wrote: I need to check if a date is within a specified date range, then C4 may return true or false C D E F 2 12-04-2008 01-03-2008 01-05-2008 3 4 if C2 is between E2 and F2 = true else = false Is there someone who can help me to make the code function that can handle this small matter:) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
check if a a date is in a specified daterange
=AND(C2=E2,C2<=F2)
-- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "H. Nissen" wrote in message ... I need to check if a date is within a specified date range, then C4 may return true or false C D E F 2 12-04-2008 01-03-2008 01-05-2008 3 4 if C2 is between E2 and F2 = true else = false Is there someone who can help me to make the code function that can handle this small matter:) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
check if a a date is in a specified daterange
Just what I needed, thank you very much :)
"Sheeloo" wrote: =AND((A2E2),(A2<F2)) will give you TRUE or FALSE... You can put an IF around it =IF(AND((A2E2),(A2<F2)),"Value if TRUE","Value if FALSE") "H. Nissen" wrote: I need to check if a date is within a specified date range, then C4 may return true or false C D E F 2 12-04-2008 01-03-2008 01-05-2008 3 4 if C2 is between E2 and F2 = true else = false Is there someone who can help me to make the code function that can handle this small matter:) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
check if a a date is in a specified daterange
Another one...
Assuming "between" means inclusive: =C2=MEDIAN(C2,E2:F2) -- Biff Microsoft Excel MVP "H. Nissen" wrote in message ... I need to check if a date is within a specified date range, then C4 may return true or false C D E F 2 12-04-2008 01-03-2008 01-05-2008 3 4 if C2 is between E2 and F2 = true else = false Is there someone who can help me to make the code function that can handle this small matter:) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with a date check formula | Excel Worksheet Functions | |||
Check input is a date | Excel Discussion (Misc queries) | |||
how can i set a date reminder to check on something in a certain. | Excel Worksheet Functions | |||
How to check valid Date value? | Excel Worksheet Functions | |||
Check if date is a business day | Excel Discussion (Misc queries) |