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