Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need true or false if a date falls between a date range
Hi there,
Simply put, I'm looking for this IF(CELL VALUE is between January 1, 2006 and January 31, 2006, True, False) Any ideas? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need true or false if a date falls between a date range
one way:
=IF(AND(C1=DATE(2006,1,1),C1<=DATE(2006,1,31)), TRUE,FALSE) Regards Trevor "Dustin" wrote in message ... Hi there, Simply put, I'm looking for this IF(CELL VALUE is between January 1, 2006 and January 31, 2006, True, False) Any ideas? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need true or false if a date falls between a date range
Just to point out that you don't really need the if statement and it will
work with just the logic ans you want a boolean answer: =AND(C2=DATE(2006,1,1),C2<=DATE(2006,1,31)) -- Hope this helps Martin Fishlock Please do not forget to rate this reply. "Trevor Shuttleworth" wrote: one way: =IF(AND(C1=DATE(2006,1,1),C1<=DATE(2006,1,31)), TRUE,FALSE) Regards Trevor "Dustin" wrote in message ... Hi there, Simply put, I'm looking for this IF(CELL VALUE is between January 1, 2006 and January 31, 2006, True, False) Any ideas? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need true or false if a date falls between a date range
If your range is always a whole month you could also use
=TEXT(A1,"mmm yy")="Jan 06" "Martin Fishlock" wrote: Just to point out that you don't really need the if statement and it will work with just the logic ans you want a boolean answer: =AND(C2=DATE(2006,1,1),C2<=DATE(2006,1,31)) -- Hope this helps Martin Fishlock Please do not forget to rate this reply. "Trevor Shuttleworth" wrote: one way: =IF(AND(C1=DATE(2006,1,1),C1<=DATE(2006,1,31)), TRUE,FALSE) Regards Trevor "Dustin" wrote in message ... Hi there, Simply put, I'm looking for this IF(CELL VALUE is between January 1, 2006 and January 31, 2006, True, False) Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
insert date | Excel Worksheet Functions | |||
Stop renaming or moving sheet tabs | Excel Discussion (Misc queries) | |||
Formula: If 2 values (in a range of six) are >3 then TRUE, FALSE | Excel Discussion (Misc queries) | |||
Match function...random search? | Excel Worksheet Functions |