If you change the display format then you should change the formula too.
Check the below formula that produces correct result for "dd mm yyyy"
format
mentioned in your email:
=IF(TEXT(A1, "dd mm yyyy") = "31 12 2012", "year end", "")
Note that this formula would work well for the year 2012 and no others.
--
Regards,
Zujar...
An optimist laughs to forget, whereas a pessimist forgets to laugh!
-----Original Message-----
From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On
Behalf
Of Mukesh
Sent: Tuesday, January 01, 2013 9:34 PM
To: accessindia@accessindia.org.in
Subject: Re: [AI] Excel formula problem
Hello zujar,
Thank you. It's working fine. I tried to do it in 'dd mm yyyy' format but
I
didn't get the appropriate result. I don't know why. If the date is in in
'dd mm yyyy' format then how to get the result. for ex. 1-1-2013 I enter
'value' instead of 'text' in formula but in vain.
Regards
Mukesh Baviskar
Mobile: 9403161157
--------------------------------------------------
From: "Zujar Shabbir Kanchwala" <zujarbri...@gmail.com>
Sent: Monday, December 31, 2012 12:43 PM
To: <accessindia@accessindia.org.in>
Subject: Re: [AI] Excel formula problem
Mukeshji,
The following formula in cell C1 should work for you:
=IF(TEXT(A1, "mmmm yyyy") = "December 2012", "year end", "")
Note the use of the format string with 4 m characters for full month
name and y character 4 full year. You can use the same string to
specify the Custom Format instead of the one with 9 m. The fourth m
tells Excel to display full month names.
Sameer,
The issue is not the date entered in A1 but the way Excel treats date
strings.
--
Regards,
Zujar...
An optimist laughs to forget, whereas a pessimist forgets to laugh!
-----Original Message-----
From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On
Behalf Of Sameer
Sent: Monday, December 31, 2012 10:25 AM
To: accessindia@accessindia.org.in
Subject: Re: [AI] Excel formula problem
Dear Friend,
Try changing the formula in cell C1 to 31/03/2012 instead of December
2012.
Regards
Mr. Sameer Latey
Mumbai, India
----- Original Message -----
From: "Mukesh" <mukeshbaviskar....@gmail.com>
To: "Access India" <accessindia@accessindia.org.in>
Sent: Sunday, December 30, 2012 10:58 PM
Subject: [AI] Excel formula problem
Dear Friends,
In my excel sheet I have created a a table. Cell 'a1' has a formula
'=today()' and cell 'c1' has a formula '=IF(A1="December 2012","year
end","")' but I am not getting the desire result in cell 'c1'. Please
check it and give me the solution at the earliest. Thank you.
Format of cell 'a1' is 'custom' 'mmmmmmmmm yyyy' date format.
Regards
Mukesh Baviskar
Mobile: 9403161157
Register at the dedicated AccessIndia list for discussing accessibility
of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessind
ia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Register at the dedicated AccessIndia list for discussing accessibility
of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessind
ia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please
visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Register at the dedicated AccessIndia list for discussing accessibility
of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessind
ia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Register at the dedicated AccessIndia list for discussing accessibility
of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessind
ia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please
visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Register at the dedicated AccessIndia list for discussing accessibility
of mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
