You're right. I mentioned the formula to match the format specified by Mukesh. "mm" stands for month in digits while "mmm" and "mmmm" stand for month name in short and full respectively.
-- 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 zoher kheriwala Sent: Wednesday, January 02, 2013 10:28 AM To: accessindia@accessindia.org.in Subject: Re: [AI] Excel formula problem Dear juzer, the formula mentioned by you in previous mail also holds good the only change that the mukesh has to do is, instead of wrighting "mmmm yyyy" wright "dd mmmm yyyy" and in true argument he has to include the date "31 december 2012", it will also work fine. zoher kheriwala taheri menswear mumbai. skype id zoher.kheriwala ----- Original Message ----- From: "Zujar Shabbir Kanchwala" <zujarbri...@gmail.com> To: <accessindia@accessindia.org.in> Sent: Wednesday, January 02, 2013 10:05 AM Subject: Re: [AI] Excel formula problem > 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_acc > essind >> 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.o >>> rg.in >>> >> >> >> Register at the dedicated AccessIndia list for discussing >> accessibility of mobile phones / Tabs on: >> > http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_acc > essind >> 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.or >> g.in >> >> >> Register at the dedicated AccessIndia list for discussing >> accessibility of > >> mobile phones / Tabs on: >> > http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_acc > essind > 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.or >> g.in >> > > Register at the dedicated AccessIndia list for discussing > accessibility of mobile phones / Tabs on: > http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_acc > essind > 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_acc > essindia.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
