You can acheave this by following formula.
note I have changed the cell address from P9 to a1.
=IF(AND(DAY(TODAY())=DAY(A1),
MONTH(TODAY())=MONTH(A1)),CHOOSE(MONTH(A1),"jan","feb","mar","app","may","jun","jul","aug","sep","oct","nov","dec"),"
")
zoher kheriwala taheri menswear mumbai. skype id zoher.kheriwala
----- Original Message -----
From: "Mukesh Baviskar" <mukeshbaviskar....@gmail.com>
To: "Access India" <accessindia@accessindia.org.in>
Sent: Wednesday, January 08, 2014 10:20 AM
Subject: [AI] Excel formula
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/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
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..
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/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
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..