Dear Viper,Pankaj & Anil,
First Thanks very much to all for spend most valuable time spend in my
solution.As per say Anil- Viper Solution is must better.But I am not say
Pankaj second solution & Anil Solution is not better, it is also good one &
I learned another trick to solution from this issue
Dear Amar,
Viper solution is good as compared to our solution. Thanks viper given a
very good logic. I appriciate ur knowledge.
Warm Regards,
Gawli Anil.
On Fri, Feb 22, 2013 at 9:54 AM, The Viper wrote:
> pfa
>
>
> On Thu, Feb 21, 2013 at 7:50 PM, pankaj sangotra wrote:
>
>> Hope this is wh
hi,all,so wat kind of skill can call Senior UI.
On Fri, Feb 22, 2013 at 12:15 AM, RAJESH ALPHASYNOPSIS <
rajesh.alphasynop...@gmail.com> wrote:
> Title:UI Developer.
>
> Location:Englewood, CO
>
> Duration:12m+
>
> 2 positions.
> Client Need Senior UI ( User Interface Developer) Consultant, Mus
This works perfectly. Thanks, Anoop.
Richard
--
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 t
You're talking yourself in the right direction...
(that is: the words you're saying should be giving you a hint as to what you
need to do!)
you have a text string: "18/12/2013"
Excel does see this as a "date", it sees it as 10 characters.
you cannot "add" a number to text.
It's like adding "thre
are you working with real date or text?
if you r working with text then try the below
=(DATE(RIGHT(A1,4),MID(A1,4,2),LEFT(A1,2)))+7
or
=TEXT((DATE(RIGHT(A1,4),MID(A1,4,2),LEFT(A1,2)))+7,"DD/MM/)
On Thu, Feb 21, 2013 at 4:01 PM, Kuldeep Singh wrote:
>
> I am already try this =A1+7. this is n
I am already try this =A1+7. this is not working. because date format is
dd/mm/
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-0120-4841100, Extn.: 2467, 9716615535
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-
assuming your date is in a1
=a1+7
On Thu, Feb 21, 2013 at 3:52 PM, Kuldeep Singh wrote:
>
> Hi All,
>
> One instant query. my format is 18/02/2013 & I want to add 7 days. Please
> help
>
> Regards,
> Kuldeep Singh
> Info Edge India Limited (naukri.com)
> Phone.: +91-0120-4841100, Extn.: 2467,
Hi All,
One instant query. my format is 18/02/2013 & I want to add 7 days. Please
help
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-0120-4841100, Extn.: 2467, 9716615535
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print
