MARIOS has attended:
Excel VBA Intro Intermediate course
ANDIF
This is a question for Mark Monroe who attended our site for an Excel 2007 course.
The first statement I know works but the second one does not as it appears not to recognise the specific date and therefore reports a true (1) answer on anything that satisfies the first criteria i.e. "Rented"
=IF(AND(J136="rented",S136>TODAY()),1,0)
=IF(AND(J136="rented",S136>08/10/2010),1,0)
How can I get it to recognise the specific date I will enter in the second part of the AND statement?
Please advise.
Thanks,
Marios
RE: ANDIF
Hi Marios,
The date part has to be specified either as the actual serial number of date, or by far the easiest, use the DateValue command.
e.g.
=if(and(A1="yes",A2>DateValue("12/5/10"),1,0)
hope that helps.
Mark
Hello xxxxxxxx,
Hope you enjoyed your Microsoft XXXXXX course with BEST Training.
Thank you for your question regarding XXXXXXXXXXXXX
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Mark
Microsoft Office Specialist Trainer
