Dear friends, Please correct this formula to get correct output. =IF(P9=TODAY(),IF(P9<>"",CHOOSE(MONTH(P9),"January","February","March","April","May","June","July","August","September","October","November","December"),""))
It's working fine if the year is 2014 but not if the year is different. Conditions: If the date is today then only the month should display else blank. The year should be ignore. For example: 08/01/2000: January 01/01/2000: blank cell 08/01/2014: January 01/01/2014: blank cell The date is in column 'p' in dd mm yyyy format. In short if the date is current date that is for today '8' then only the month should be display in the output. Please suggest me a correction to get correct output. Thank you. Regards, Mukesh Baviskar Mobile: 9403161157 Time to meet up again! Register for AccessIndia Convention 2014: http://accessindia.org.in/harish/convention.htm 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 Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list..
