Re: $$Excel-Macros$$ How to execute a function only if the cell is not blank

2016-02-07 Thread Abhishek Jain
=IF(G:G<>"",MONTH(G:G),"") HTH On Mon, Feb 8, 2016 at 12:28 PM, James Johnston wrote: > Hey guys, I am creating a budget. I set up a google form to enter > expenses and now am trying to create the backend. > > So far I have one sheet for the transactions

Re: $$Excel-Macros$$ removes the jpeg extension

2016-02-07 Thread GENIUS
HI Thank you very much Mr. Ravinder Negi, that's really great -- 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

Re: $$Excel-Macros$$ Date formula for Age Calculation

2016-02-07 Thread GENIUS
LOOK AT THE ATTACHMENT -- 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

$$Excel-Macros$$ Need Excel Macro Training

2016-02-07 Thread Prabhakar Thakur
Hi Group Member I need excel macro training please share best training institute details or share link Thanks, Prabhakar Thakur New Delhi +919953736776 -- 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$$ Date formula for Age Calculation

2016-02-07 Thread amar takale
Dear all thanks for reply but i cant understand what you say.I except only date formula in column D. On Sun, Feb 7, 2016 at 9:36 PM, GENIUS wrote: > LOOK AT THE ATTACHMENT > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >

$$Excel-Macros$$ How to execute a function only if the cell is not blank

2016-02-07 Thread James Johnston
Hey guys, I am creating a budget. I set up a google form to enter expenses and now am trying to create the backend. So far I have one sheet for the transactions automatically filled when I use the form, and copied that to a separate data sheet using Importrange, now I am trying to turn the