bcoz it will be calculated for 360 days/year
no problem just go for this simple technique
=enddate-startdate+1
From
Naveenkumar
On Wed, Feb 12, 2014 at 10:07 AM, Shankar Bheema wrote:
> Thank you naveen for providing solution
>
> Wherein, the difference between dates from 01-01-2014 to 31-01-
Dear Friends, Any solution on this issue?
On Tue, Feb 11, 2014 at 3:41 PM, amar takale wrote:
> Dear Sir
> Pls see sheet which I want output in excel in different column
> Regards
> Amar
>
>
> On Tue, Feb 11, 2014 at 3:16 PM, wrote:
>
>> Try this
>>
>>
>>
>> *From:* excel-macros@googlegroups.c
Thank you naveen for providing solution
Wherein, the difference between dates from 01-01-2014 to 31-01-2014 is 31
days, but with the formula it is showing 30 days just short of 1 day. How
can I get the one day added to that column
On Tue, Feb 11, 2014 at 6:03 PM, Naveen Kumar M N <
naveenkumarm
Read Rule No. 3
Regards,
Sam Mathai Chacko
On Wed, Feb 12, 2014 at 1:00 AM, Bernardo Pereira wrote:
> Here's the file I need to crack!! Please help me!!
>
> Tks
>
> --
> 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 pag
Hello,
I created a password to protect my VBA project but I can't remember it!!
Now I'm stuck with the file and can't open the codes.
Can someone help me out??
Tks
--
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 o
Hi,
try this...
format the column as DATE & put start_date at the first cell
then
=if(start_date <=end_date,start_date+1,"")
From
Naveenkumar
On Tue, Feb 11, 2014 at 3:30 PM, KATHIRVELAN N wrote:
> Dear Friends,
>
> Please find the below details for more understanding.
>
> Bill Date For the M
Dear Friends,
Please find the below details for more understanding.
Bill Date For the Month Period From For the Month Period To 03-Feb-14
02-Jan-14 01-Feb-14 06-Feb-14 05-Jan-14 04-Feb-14 17-Feb-14 16-Jan-14
15-Feb-14
On Tue, Feb 11, 2014 at 3:00 PM, Sandeep Kumar Chhajer <
chhajersand...@
Pfa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sundarvelan N
Sent: Tuesday, February 11, 2014 2:54 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ calculate previous month dates using the given
date
I need,
2 Jan to 1 Feb
Can you give another example so that the logic get clear! Like what do you want
if given date is 25th December 2013. 24th November to 23rd December?
Thanks & Regards,
Sandeep Kumar Chhajer
Mumbai
India
Sent on my BlackBerry(R) from Vodafone
-Original Message-
From: Sundarvelan N
Sende
I need,
2 Jan to 1 Feb
Thanks
N.Sundarvelan
9600160150
On Tue, Feb 11, 2014 at 2:44 PM, DILIPandey wrote:
> Hi Kathirvelan,
>
> You need dates between 2Jan to 1 Feb
> or, 2 Jan to 3 Feb ?
>
>
>
> On Tue, Feb 11, 2014 at 12:44 PM, KATHIRVELAN N wrote:
>
>> Dear Friends,
>>
>> I need to calcu
Hi Kathirvelan,
You need dates between 2Jan to 1 Feb
or, 2 Jan to 3 Feb ?
On Tue, Feb 11, 2014 at 12:44 PM, KATHIRVELAN N wrote:
> Dear Friends,
>
> I need to calculate previous month dates using the given date
>
> Given Date : 03-Feb-2014
>
> From Date Should Be : 02-Jan-2014
>
> To Date : 01
Dear Sir
I Replace all B27cell to B3 in formula but wrong answer,How to work it Pls
explain me.
Regards
Amar
On Tue, Feb 11, 2014 at 2:19 PM, wrote:
> Try below mentioned
>
> Change cell ref..
>
> =LEFT(B27,LEN(B27)-FIND("MT.",B27,1)+3)
>
>
>
>
>
> *From:* excel-macros@googlegroups.com [mailto
Thanks a lot.
On Tue, Feb 11, 2014 at 2:00 PM, Abhishek Jain wrote:
> Please see the attached.
>
> HTH
>
>
> On Tue, Feb 11, 2014 at 1:27 PM, Kundan Tiwary wrote:
>
>> Hi,
>>
>> Attached is the sample file,
>>
>> In the monthly part I need only monthly details and in the annual part
>> annual da
Try below mentioned
Change cell ref..
=LEFT(B27,LEN(B27)-FIND("MT.",B27,1)+3)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of amar takale
Sent: Tuesday, February 11, 2014 1:47 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ MID functio
Dear Friends,
I need to calculate previous month dates using the given date
Given Date : 03-Feb-2014
>From Date Should Be : 02-Jan-2014
To Date : 01-Feb-2014
Thanks,
Kathirvelan
--
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
Check if this help.
Regards,
Amit Desai
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Kundan Tiwary
Sent: 11 February 2014 13:27
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Sumif Based on 2 conditions
Hi,
Attached is the sample file,
Hi,
PFA
Regards,
Deepak Rawat
On Tue, Feb 11, 2014 at 1:27 PM, Kundan Tiwary wrote:
> Hi,
>
> Attached is the sample file,
>
> In the monthly part I need only monthly details and in the annual part
> annual data.
>
> The data has to meet the condition based on branch and Detail
>
>
> On Tue, F
Please see the attached.
HTH
On Tue, Feb 11, 2014 at 1:27 PM, Kundan Tiwary wrote:
> Hi,
>
> Attached is the sample file,
>
> In the monthly part I need only monthly details and in the annual part
> annual data.
>
> The data has to meet the condition based on branch and Detail
>
>
> On Tue, Feb
18 matches
Mail list logo
