I appreciate the help from my last question, hope this one will be just as simple for you excel guru's.
My issue this time is I want them to input 3 dates.
A1 DATE1
B1 DATE2
C1 DATE3
Need to figure out if DATE1 is within 120 days before or after DATE3 AND also must be prior to or same as DATE2 to say yes
if DATE1is not within 120 days from DATE3 OR its not before DATE2 will say no.
any takers? thanks in advance.
Last edited by Argile79; 04-13-2010 at 05:23 PM.
How about a formula:
=IF(AND(ABS(C1-A1)<=120, A1<=B1), "Yes", "No")
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hey man, thanks for the start, but its not quite doing what i need it to.
I don't know if the format for my Date cells are right, i have to manually type in the date, like 01/25/2010, and im not sure if your formula is able to check it if its a previous year or more. Let alone be able to count the days during each month for that year.
I tried it at first and it worked, then when i went back further it kept saying yes, when it should of been no. then when i went WAY back it said no, but i don't think its pulling the infor right. Any suggestions? Its racking my brain. thanks
Or need me to clarify again what i want?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks