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 wrote: > Thanks bro!! > > On Wed, Nov 26, 2014 at 10:45 AM, Vaibhav Joshi wrote: > >> hi >> >> when you multiply by 1, xl converts it to date. >> >> Try this in excel,

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 wrote: > hi > > when you multiply by 1, xl converts it to date. > > Try this in excel, put this formula cell E2 =DATE(20&RIGHT(D2,2),3,31), > now goto format cell & change date format to dd/mmm/yy or any other format, > result wont cha

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(20&RIGHT(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 form

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(20&RIGHT(D2,2),3,31)*1 Thanks a lot! Regards, Ganesh N On Tue, Nov 25, 2014 at 8:17 PM, Vaibhav Joshi wrote: > hi > > check this... > > In blue i have given formula using helper columns & in yellow its direct > one.. > > C

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 wrote: > Dear Mandeep, > > Please see the header I mean the financial y

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 B

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 UT

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 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 wrot

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 wrote: > USE DATEDIF FUNCTION > > On Fri, Nov 21, 2014 at 7:55 AM, Ganesh N wrote: > >> Dear team, >> >> Need a help on formula to fin

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 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, > Ga

$$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 =TIM