here is the solution,
=IF(AND(DAY(TODAY())=DAY(A1),
MONTH(TODAY())=MONTH(A1)),"today",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: "AccessIndia: a list for discussing accessibility and issuesconcerning
thedisabled." <accessindia@accessindia.org.in>
Sent: Thursday, January 09, 2014 9:59 PM
Subject: Re: [AI] Excel formula
Hi Johar,
The example is as follows:
01/01/1999: January
09/01/1999: Today
12/01/2011: January
09/01/2014: Today
09/01/1934: Today
11/02/14:
31/3/2012:
09/01/1911: Today
Thank you and good night!
Regards,
Mukesh Baviskar
Mobile: 9403161157
--------------------------------------------------
From: "zoher kheriwala" <zos...@gmail.com>
Sent: Thursday, January 09, 2014 7:56 PM
To: "AccessIndia: a list for discussing accessibility and issuesconcerning
thedisabled." <accessindia@accessindia.org.in>
Subject: Re: [AI] Excel formula
I am not getting your question, so kindly provide me with some examples.
zoher kheriwala taheri menswear mumbai. skype id zoher.kheriwala
----- Original Message -----
From: "Mukesh Baviskar" <mukeshbaviskar....@gmail.com>
To: "AccessIndia: a list for discussing accessibility and
issuesconcerning thedisabled." <accessindia@accessindia.org.in>
Sent: Thursday, January 09, 2014 7:01 PM
Subject: Re: [AI] Excel formula
Hi Johar,
Thank you. It's working fine.
Actually, I want to create a list of today's birthdays and a list of
birthdays in that particular months.
The formula you suggested is creating a list of today's birthdays. I
understood after seeing the output. So in this formula I want a remark
'Today' and not the particular month.
Secondly, I want a remark 'particular month' when the birthday is in
that particular month. So the remark should be the name of that month
ignoring the day and year.
Is it possible?
Thank you for solution.
Regards,
Mukesh Baviskar
Mobile: 9403161157
--------------------------------------------------
From: "zoher kheriwala" <zos...@gmail.com>
Sent: Thursday, January 09, 2014 12:01 PM
To: "AccessIndia: a list for discussing accessibility and
issuesconcerning thedisabled." <accessindia@accessindia.org.in>
Subject: Re: [AI] Excel formula
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..
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..
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..