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:[email protected]] On Behalf Of Mukesh Sent: Tuesday, January 01, 2013 9:34 PM To: [email protected] 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" <[email protected]> Sent: Monday, December 31, 2012 12:43 PM To: <[email protected]> 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:[email protected]] On > Behalf Of Sameer > Sent: Monday, December 31, 2012 10:25 AM > To: [email protected] > 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" <[email protected]> > To: "Access India" <[email protected]> > 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/[email protected]/ >> >> To unsubscribe send a message to >> [email protected] >> 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/[email protected]/ > > To unsubscribe send a message to > [email protected] > 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/[email protected]/ > > To unsubscribe send a message to > [email protected] > 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/[email protected]/ To unsubscribe send a message to [email protected] 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/[email protected]/ To unsubscribe send a message to [email protected] 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
