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_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
