Hi,
Can someone please help me in finding if date range in column H (Case Date 2) falls between date range in Column D and Column E. (Please see attached sample workbook)
For Example, It should be “Y” for Client ID 1 because 18 may lies between 4 May and June 1 and it should be “N” for client 16 because 16 April does not fall between 16 Feb and 16 March.
I have sample of 2000, people so I really cannot do it by hand.
Thank you for the help.
Last edited by ajang; 10-15-2010 at 06:35 PM.
In I2
=IF(AND(H2>=D2,H2<=E2),"Y","N")
Is that what you are looking for?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Yes, And it works. Thank UOriginally Posted by ChemistB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks