If Statements with Dates
I am trying to build a If statement using dates, I am getting all True the
forumla I have built is =IF(B659/15/06,"true","") B65=9/1/06 What am I doing wrong? |
If Statements with Dates
=IF(B65DATE(2006,9,15),"true","")
or =IF(B65--"2006-09-15","true","") -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Erika" wrote in message ... I am trying to build a If statement using dates, I am getting all True the forumla I have built is =IF(B659/15/06,"true","") B65=9/1/06 What am I doing wrong? |
If Statements with Dates
TRY:
=IF(B1DATEVALUE("15/9/06"),"true","") "Erika" wrote: I am trying to build a If statement using dates, I am getting all True the forumla I have built is =IF(B659/15/06,"true","") B65=9/1/06 What am I doing wrong? |
If Statements with Dates
I entered =IF(B65DATEVALUE("15/9/06"),"true","") and got a Value error
"Toppers" wrote: TRY: =IF(B1DATEVALUE("15/9/06"),"true","") "Erika" wrote: I am trying to build a If statement using dates, I am getting all True the forumla I have built is =IF(B659/15/06,"true","") B65=9/1/06 What am I doing wrong? |
If Statements with Dates
It might be easier, if this is something you do often with different dates,
to enter the date you want to check against in a cell. If 9/15/06 is in cell D1, then =if(B65$D$1,"True","") works as well. Then you can change the date in cell D1 at anytime without having to re-enter the formula. "Erika" wrote: I am trying to build a If statement using dates, I am getting all True the forumla I have built is =IF(B659/15/06,"true","") B65=9/1/06 What am I doing wrong? |
If Statements with Dates
Probably because Toppers uses UK style dates, you use US. Which is why you
should never use ambiguous date strings like that, see my earlier response on how to overcome it. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Erika" wrote in message ... I entered =IF(B65DATEVALUE("15/9/06"),"true","") and got a Value error "Toppers" wrote: TRY: =IF(B1DATEVALUE("15/9/06"),"true","") "Erika" wrote: I am trying to build a If statement using dates, I am getting all True the forumla I have built is =IF(B659/15/06,"true","") B65=9/1/06 What am I doing wrong? |
If Statements with Dates
Bob,
Good point (and carelessness on my part in my response). I MUST(!) use the DATE function in future (write out 100 times). "Bob Phillips" wrote: Probably because Toppers uses UK style dates, you use US. Which is why you should never use ambiguous date strings like that, see my earlier response on how to overcome it. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Erika" wrote in message ... I entered =IF(B65DATEVALUE("15/9/06"),"true","") and got a Value error "Toppers" wrote: TRY: =IF(B1DATEVALUE("15/9/06"),"true","") "Erika" wrote: I am trying to build a If statement using dates, I am getting all True the forumla I have built is =IF(B659/15/06,"true","") B65=9/1/06 What am I doing wrong? |
All times are GMT +1. The time now is 11:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com