Re: $$Excel-Macros$$ Formula to find the month btwn the financial year
hi check this... In blue i have given formula using helper columns in yellow its direct one.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Fri, Nov 21, 2014 at 4:50 PM, Ganesh N ganeshg...@gmail.com wrote: Dear Mandeep, Please see the header I mean the financial year if it is FY 15-16 that means I what to find the month in apr 15- Mar 16 in the given time period 1 april and 30 june 19. Im I clear or need more clarification ? Thanks Regards, Ganesh N On Fri, Nov 21, 2014 at 3:30 PM, Mandeep Baluja rockerna...@gmail.com wrote: How can be the no of months between 1 april and 30 june 19 is 12 ? what you are saying. Regards, Mandeep baluja *Month**End Month**FY 15-16**FY 16-17**FY 17-18**FY 18-19**FY 19-20**FY 20-21* *1-Apr-15**30-Jun-19**12**12**12**12**3**0* On Friday, November 21, 2014 3:27:20 PM UTC+5:30, Ganesh N wrote: Dear team, Any update on the request ? Thanks Regards, Ganesh N On Fri, Nov 21, 2014 at 2:14 PM, Ganesh N ganes...@gmail.com wrote: I tried but I not able to find the exact month btwn the year... So I need the help on that... Regards, Ganesh N On Fri, Nov 21, 2014 at 2:07 PM, Hilary Lomotey res...@gmail.com wrote: USE DATEDIF FUNCTION On Fri, Nov 21, 2014 at 7:55 AM, Ganesh N ganes...@gmail.com wrote: Dear team, Need a help on formula to find the month btwn the years.. pls find the attachement. Note: its should calculate from Apr - Mar I tried but I not able to get the correct one. Thanks Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this
Re: $$Excel-Macros$$ Formula to find the month btwn the financial year
Thanks Vaibhav ji, Got it. But can you pls explain how this works =DATE(20RIGHT(D2,2),3,31)*1 Thanks a lot! Regards, Ganesh N On Tue, Nov 25, 2014 at 8:17 PM, Vaibhav Joshi v...@vabs.in wrote: hi check this... In blue i have given formula using helper columns in yellow its direct one.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Fri, Nov 21, 2014 at 4:50 PM, Ganesh N ganeshg...@gmail.com wrote: Dear Mandeep, Please see the header I mean the financial year if it is FY 15-16 that means I what to find the month in apr 15- Mar 16 in the given time period 1 april and 30 june 19. Im I clear or need more clarification ? Thanks Regards, Ganesh N On Fri, Nov 21, 2014 at 3:30 PM, Mandeep Baluja rockerna...@gmail.com wrote: How can be the no of months between 1 april and 30 june 19 is 12 ? what you are saying. Regards, Mandeep baluja *Month**End Month**FY 15-16**FY 16-17**FY 17-18**FY 18-19**FY 19-20**FY 20-21* *1-Apr-15**30-Jun-19**12**12**12**12**3**0* On Friday, November 21, 2014 3:27:20 PM UTC+5:30, Ganesh N wrote: Dear team, Any update on the request ? Thanks Regards, Ganesh N On Fri, Nov 21, 2014 at 2:14 PM, Ganesh N ganes...@gmail.com wrote: I tried but I not able to find the exact month btwn the year... So I need the help on that... Regards, Ganesh N On Fri, Nov 21, 2014 at 2:07 PM, Hilary Lomotey res...@gmail.com wrote: USE DATEDIF FUNCTION On Fri, Nov 21, 2014 at 7:55 AM, Ganesh N ganes...@gmail.com wrote: Dear team, Need a help on formula to find the month btwn the years.. pls find the attachement. Note: its should calculate from Apr - Mar I tried but I not able to get the correct one. Thanks Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a
Re: $$Excel-Macros$$ Formula to find the month btwn the financial year
hi when you multiply by 1, xl converts it to date. Try this in excel, put this formula cell E2 =DATE(20RIGHT(D2,2),3,31), now goto format cell change date format to dd/mmm/yy or any other format, result wont change. Now in next celll put formula =E2*1 now goto format cell change date format to dd/mmm/yy or any other format. Cheers!! + *I did not do this for you. God is here working through me for you.* On Wed, Nov 26, 2014 at 9:11 AM, Ganesh N ganeshg...@gmail.com wrote: Thanks Vaibhav ji, Got it. But can you pls explain how this works =DATE(20RIGHT(D2,2),3,31)*1 Thanks a lot! Regards, Ganesh N On Tue, Nov 25, 2014 at 8:17 PM, Vaibhav Joshi v...@vabs.in wrote: hi check this... In blue i have given formula using helper columns in yellow its direct one.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Fri, Nov 21, 2014 at 4:50 PM, Ganesh N ganeshg...@gmail.com wrote: Dear Mandeep, Please see the header I mean the financial year if it is FY 15-16 that means I what to find the month in apr 15- Mar 16 in the given time period 1 april and 30 june 19. Im I clear or need more clarification ? Thanks Regards, Ganesh N On Fri, Nov 21, 2014 at 3:30 PM, Mandeep Baluja rockerna...@gmail.com wrote: How can be the no of months between 1 april and 30 june 19 is 12 ? what you are saying. Regards, Mandeep baluja *Month**End Month**FY 15-16**FY 16-17**FY 17-18**FY 18-19**FY 19-20**FY 20-21* *1-Apr-15**30-Jun-19**12**12**12**12**3**0* On Friday, November 21, 2014 3:27:20 PM UTC+5:30, Ganesh N wrote: Dear team, Any update on the request ? Thanks Regards, Ganesh N On Fri, Nov 21, 2014 at 2:14 PM, Ganesh N ganes...@gmail.com wrote: I tried but I not able to find the exact month btwn the year... So I need the help on that... Regards, Ganesh N On Fri, Nov 21, 2014 at 2:07 PM, Hilary Lomotey res...@gmail.com wrote: USE DATEDIF FUNCTION On Fri, Nov 21, 2014 at 7:55 AM, Ganesh N ganes...@gmail.com wrote: Dear team, Need a help on formula to find the month btwn the years.. pls find the attachement. Note: its should calculate from Apr - Mar I tried but I not able to get the correct one. Thanks Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor
Re: $$Excel-Macros$$ Formula to find the month btwn the financial year
Thanks bro!! On Wed, Nov 26, 2014 at 10:45 AM, Vaibhav Joshi v...@vabs.in wrote: hi when you multiply by 1, xl converts it to date. Try this in excel, put this formula cell E2 =DATE(20RIGHT(D2,2),3,31), now goto format cell change date format to dd/mmm/yy or any other format, result wont change. Now in next celll put formula =E2*1 now goto format cell change date format to dd/mmm/yy or any other format. Cheers!! + *I did not do this for you. God is here working through me for you.* On Wed, Nov 26, 2014 at 9:11 AM, Ganesh N ganeshg...@gmail.com wrote: Thanks Vaibhav ji, Got it. But can you pls explain how this works =DATE(20RIGHT(D2,2),3,31)*1 Thanks a lot! Regards, Ganesh N On Tue, Nov 25, 2014 at 8:17 PM, Vaibhav Joshi v...@vabs.in wrote: hi check this... In blue i have given formula using helper columns in yellow its direct one.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Fri, Nov 21, 2014 at 4:50 PM, Ganesh N ganeshg...@gmail.com wrote: Dear Mandeep, Please see the header I mean the financial year if it is FY 15-16 that means I what to find the month in apr 15- Mar 16 in the given time period 1 april and 30 june 19. Im I clear or need more clarification ? Thanks Regards, Ganesh N On Fri, Nov 21, 2014 at 3:30 PM, Mandeep Baluja rockerna...@gmail.com wrote: How can be the no of months between 1 april and 30 june 19 is 12 ? what you are saying. Regards, Mandeep baluja *Month**End Month**FY 15-16**FY 16-17**FY 17-18**FY 18-19**FY 19-20**FY 20-21* *1-Apr-15**30-Jun-19**12**12**12**12**3**0* On Friday, November 21, 2014 3:27:20 PM UTC+5:30, Ganesh N wrote: Dear team, Any update on the request ? Thanks Regards, Ganesh N On Fri, Nov 21, 2014 at 2:14 PM, Ganesh N ganes...@gmail.com wrote: I tried but I not able to find the exact month btwn the year... So I need the help on that... Regards, Ganesh N On Fri, Nov 21, 2014 at 2:07 PM, Hilary Lomotey res...@gmail.com wrote: USE DATEDIF FUNCTION On Fri, Nov 21, 2014 at 7:55 AM, Ganesh N ganes...@gmail.com wrote: Dear team, Need a help on formula to find the month btwn the years.. pls find the attachement. Note: its should calculate from Apr - Mar I tried but I not able to get the correct one. Thanks Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
Re: $$Excel-Macros$$ Formula to find the month btwn the financial year
cheers!! + *I did not do this for you. God is here working through me for you.* On Wed, Nov 26, 2014 at 11:36 AM, Ganesh N ganeshg...@gmail.com wrote: Thanks bro!! On Wed, Nov 26, 2014 at 10:45 AM, Vaibhav Joshi v...@vabs.in wrote: hi when you multiply by 1, xl converts it to date. Try this in excel, put this formula cell E2 =DATE(20RIGHT(D2,2),3,31), now goto format cell change date format to dd/mmm/yy or any other format, result wont change. Now in next celll put formula =E2*1 now goto format cell change date format to dd/mmm/yy or any other format. Cheers!! + *I did not do this for you. God is here working through me for you.* On Wed, Nov 26, 2014 at 9:11 AM, Ganesh N ganeshg...@gmail.com wrote: Thanks Vaibhav ji, Got it. But can you pls explain how this works =DATE(20RIGHT(D2,2),3,31)*1 Thanks a lot! Regards, Ganesh N On Tue, Nov 25, 2014 at 8:17 PM, Vaibhav Joshi v...@vabs.in wrote: hi check this... In blue i have given formula using helper columns in yellow its direct one.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Fri, Nov 21, 2014 at 4:50 PM, Ganesh N ganeshg...@gmail.com wrote: Dear Mandeep, Please see the header I mean the financial year if it is FY 15-16 that means I what to find the month in apr 15- Mar 16 in the given time period 1 april and 30 june 19. Im I clear or need more clarification ? Thanks Regards, Ganesh N On Fri, Nov 21, 2014 at 3:30 PM, Mandeep Baluja rockerna...@gmail.com wrote: How can be the no of months between 1 april and 30 june 19 is 12 ? what you are saying. Regards, Mandeep baluja *Month**End Month**FY 15-16**FY 16-17**FY 17-18**FY 18-19**FY 19-20**FY 20-21* *1-Apr-15**30-Jun-19**12**12**12**12**3**0* On Friday, November 21, 2014 3:27:20 PM UTC+5:30, Ganesh N wrote: Dear team, Any update on the request ? Thanks Regards, Ganesh N On Fri, Nov 21, 2014 at 2:14 PM, Ganesh N ganes...@gmail.com wrote: I tried but I not able to find the exact month btwn the year... So I need the help on that... Regards, Ganesh N On Fri, Nov 21, 2014 at 2:07 PM, Hilary Lomotey res...@gmail.com wrote: USE DATEDIF FUNCTION On Fri, Nov 21, 2014 at 7:55 AM, Ganesh N ganes...@gmail.com wrote: Dear team, Need a help on formula to find the month btwn the years.. pls find the attachement. Note: its should calculate from Apr - Mar I tried but I not able to get the correct one. Thanks Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit
Re: $$Excel-Macros$$ Formula to find the month btwn the financial year
USE DATEDIF FUNCTION On Fri, Nov 21, 2014 at 7:55 AM, Ganesh N ganeshg...@gmail.com wrote: Dear team, Need a help on formula to find the month btwn the years.. pls find the attachement. Note: its should calculate from Apr - Mar I tried but I not able to get the correct one. Thanks Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Formula to find the month btwn the financial year
I tried but I not able to find the exact month btwn the year... So I need the help on that... Regards, Ganesh N On Fri, Nov 21, 2014 at 2:07 PM, Hilary Lomotey resp...@gmail.com wrote: USE DATEDIF FUNCTION On Fri, Nov 21, 2014 at 7:55 AM, Ganesh N ganeshg...@gmail.com wrote: Dear team, Need a help on formula to find the month btwn the years.. pls find the attachement. Note: its should calculate from Apr - Mar I tried but I not able to get the correct one. Thanks Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Formula to find the month btwn the financial year
Dear team, Any update on the request ? Thanks Regards, Ganesh N On Fri, Nov 21, 2014 at 2:14 PM, Ganesh N ganeshg...@gmail.com wrote: I tried but I not able to find the exact month btwn the year... So I need the help on that... Regards, Ganesh N On Fri, Nov 21, 2014 at 2:07 PM, Hilary Lomotey resp...@gmail.com wrote: USE DATEDIF FUNCTION On Fri, Nov 21, 2014 at 7:55 AM, Ganesh N ganeshg...@gmail.com wrote: Dear team, Need a help on formula to find the month btwn the years.. pls find the attachement. Note: its should calculate from Apr - Mar I tried but I not able to get the correct one. Thanks Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Formula to find the month btwn the financial year
How can be the no of months between 1 april and 30 june 19 is 12 ? what you are saying. Regards, Mandeep baluja *Month**End Month**FY 15-16**FY 16-17**FY 17-18**FY 18-19**FY 19-20**FY 20-21* *1-Apr-15**30-Jun-19**12**12**12**12**3**0* On Friday, November 21, 2014 3:27:20 PM UTC+5:30, Ganesh N wrote: Dear team, Any update on the request ? Thanks Regards, Ganesh N On Fri, Nov 21, 2014 at 2:14 PM, Ganesh N ganes...@gmail.com javascript: wrote: I tried but I not able to find the exact month btwn the year... So I need the help on that... Regards, Ganesh N On Fri, Nov 21, 2014 at 2:07 PM, Hilary Lomotey res...@gmail.com javascript: wrote: USE DATEDIF FUNCTION On Fri, Nov 21, 2014 at 7:55 AM, Ganesh N ganes...@gmail.com javascript: wrote: Dear team, Need a help on formula to find the month btwn the years.. pls find the attachement. Note: its should calculate from Apr - Mar I tried but I not able to get the correct one. Thanks Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Formula to find the month btwn the financial year
Dear Mandeep, Please see the header I mean the financial year if it is FY 15-16 that means I what to find the month in apr 15- Mar 16 in the given time period 1 april and 30 june 19. Im I clear or need more clarification ? Thanks Regards, Ganesh N On Fri, Nov 21, 2014 at 3:30 PM, Mandeep Baluja rockerna...@gmail.com wrote: How can be the no of months between 1 april and 30 june 19 is 12 ? what you are saying. Regards, Mandeep baluja *Month**End Month**FY 15-16**FY 16-17**FY 17-18**FY 18-19**FY 19-20**FY 20-21* *1-Apr-15**30-Jun-19**12**12**12**12**3**0* On Friday, November 21, 2014 3:27:20 PM UTC+5:30, Ganesh N wrote: Dear team, Any update on the request ? Thanks Regards, Ganesh N On Fri, Nov 21, 2014 at 2:14 PM, Ganesh N ganes...@gmail.com wrote: I tried but I not able to find the exact month btwn the year... So I need the help on that... Regards, Ganesh N On Fri, Nov 21, 2014 at 2:07 PM, Hilary Lomotey res...@gmail.com wrote: USE DATEDIF FUNCTION On Fri, Nov 21, 2014 at 7:55 AM, Ganesh N ganes...@gmail.com wrote: Dear team, Need a help on formula to find the month btwn the years.. pls find the attachement. Note: its should calculate from Apr - Mar I tried but I not able to get the correct one. Thanks Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit
$$Excel-Macros$$ Formula to find the month btwn the financial year
Dear team, Need a help on formula to find the month btwn the years.. pls find the attachement. Note: its should calculate from Apr - Mar I tried but I not able to get the correct one. Thanks Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Sample data.xlsx Description: MS-Excel 2007 spreadsheet