Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Between two dates
I have three dates on the spreadsheet and I need to know if the third date is
within the parameters of the first two... Column J = 03/21/07 (start date) column K = 05/15/07 (end date) column T = 03/06/07 (date to be checked) I need a forumla that will tell me if the third date is within the first two. Please help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Between two dates
Try this:
=IF(AND(T1=J1,T1<=K1),"within","outside")&" range" This assumes the range includes the start and end dates, but if the range is exclusive of these dates then you can use: =IF(AND(T1J1,T1<K1),"within","outside")&" range" Hope this helps. Pete On Dec 10, 2:47*pm, jen-chi wrote: I have three dates on the spreadsheet and I need to know if the third date is within the parameters of the first two... * Column J = 03/21/07 (start date) column K = 05/15/07 (end date) column T = 03/06/07 (date to be checked) I need a forumla that will tell me if the third date is within the first two. * *Please help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Between two dates
This will return TRUE or FALSE
=(AND(T1J1,T1<K1) This will return whatever text you want =IF(AND(T1J1,T1<K1),"OK,"Bad") I have taken 'between' literally. So if T-date is exactly the same as J-date you get false You may wish to use =(AND(T1=J1,T1<=K1) to include the two critical dates best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "jen-chi" wrote in message ... I have three dates on the spreadsheet and I need to know if the third date is within the parameters of the first two... Column J = 03/21/07 (start date) column K = 05/15/07 (end date) column T = 03/06/07 (date to be checked) I need a forumla that will tell me if the third date is within the first two. Please help |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Between two dates
This returns True if between dates,
False if not: =AND(T1=J1,T1<=K1) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "jen-chi" wrote in message ... I have three dates on the spreadsheet and I need to know if the third date is within the parameters of the first two... Column J = 03/21/07 (start date) column K = 05/15/07 (end date) column T = 03/06/07 (date to be checked) I need a forumla that will tell me if the third date is within the first two. Please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop dates from showing as numbers - when formated as dates | Excel Discussion (Misc queries) | |||
compare 2 tables of dates to find the preceding dates | Excel Worksheet Functions | |||
Identifying unique dates within a range of cells containing dates | Excel Discussion (Misc queries) | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Charting data against dates where dates are not at fixed intervals | Charts and Charting in Excel |