Dear Expert,
Is it possible to get the result as month if month has been passed from Jan to Dec then the month name or else result will be blank. For e.g. if current running month is October then the list by using the formula will give result from Jan to Oct and for rest two month results will be blank.
Please do let me know if needs further clarification.
Thank you for your valuable support.
Regards,
Neilesh
By now Neilesh.... you should know that a sample sheet is far more use than a vague description.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Dear Experts,
Please find here attached sample workbook where if the Oct month is running then the formula will give the results from Jan till Oct and if rest two months Nov and Dec is yet to come then the results will be blank.
Regards,
Neilesh
Hi, try this:
=IF(MONTH(TODAY())>=A2,TEXT(DATE(2018,A2,1),"mmm"),"")
There is no need to adjust the 2018 when the year changes.
Dear Expert, Thank you for your support expected results are giving the perfect from Jan to Oct but the Nov and Dec for Cell B12 and B13 expecting as blank which are giving output as Nov and Dec. As per message # 1, if the current month if October then the results are expecting months name from Jan to Oct and rest two other months Nov and Dec as blank.
Dear Expert Glenn, Thank you so much i have by changing the month in control panel and the output is giving perfect. Thank you once again.
since we are in December month so the output is giving from Jan to Dec
Dear Expert, in the provided formula =IF(MONTH(TODAY())>=A2,TEXT(DATE(2018,A2,1),"mmm"),""), if i do change the year from 2018 to 2019 then the output is giving for all the 12 months. Can you please look into the same.
When you say"if i do change the year from 2018 to 2019" where? In the formula? In the PC settings, and if so, which month have you selected?
I think you mean you changed the year in the PC settings, but left the month as December, so it will give all 12...
Is there any chances Sir the without changing the PC Clock if i do change the year in the formula from 2018 to 2019 then the output will be blank.
Please find here attached revised sample workbook with the year dropdown. If i do change the year from the dropdown then the passed and current month name will be appeared but the year is not arrived then blank.
Thank you for your valuable support.
???
In B2, copied down:
=IF($F$2>YEAR(TODAY()),"",IF(MONTH(TODAY())>=A2,TEXT(DATE(2018,A2,1),"mmm"),""))
The 2018 in the formula does NOTHING other than help the formula produce Jan as the result rather than the month number.
It will work just as well with your year of birth, or the year of India.s Independence....
Perfect Solution Sir. Thank you so much
Another version, avoiding the 2018 in the formula might be:
=IF($F$2>YEAR(TODAY()),"",IF(MONTH(TODAY())>=A2,LOOKUP(A2,ROW($1:$12),{"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"}),""))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks