Thanks Paul and xls Yes this is the alternate method I have seen and it is
achieved with your formula.
On Friday, December 12, 2014 5:48:05 PM UTC+5:30, Mandeep Baluja wrote:
>
> Just for knowledge can we get the number *Dates* between two dates. I am
> trying to achieve with array. I saw it
Friday, December 12, 2014 8:01 AM
>Subject: Re: $$Excel-Macros$$ Re: Dates
>
>
>
>Request Please read my question It's not about getting number of Days between
>two dates.
>
>
>See dis what i want.
>
>
> Like Start date
>A1
>12/12/2014
>end date
--
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: Mandeep
Request Please read my question It's not about getting number of Days
between two dates.
See dis what i want.
Like Start date
A1
12/12/2014
end date
B1
12/22/2014
Formula should return in number of rows.
C1,c2,c3,c4,c5
want this Broo.
13/12/2014
14/12/2014
15/12/2014
16/12/2014
17/
Sir,
Check this
[image: Inline image 1]
On Fri, Dec 12, 2014 at 6:07 PM, Mandeep Baluja
wrote:
>
> Hey paul,
>
> Thanks for reply I have highlighted number of *Dates *not days. I want
> number of dates between two dates.
>
> Like Start date
> 12/12/2014
> end date
> 12/22/2014
>
> Formula shou
Hey paul,
Thanks for reply I have highlighted number of *Dates *not days. I want
number of dates between two dates.
Like Start date
12/12/2014
end date
12/22/2014
Formula should return 13/12/2014
14/12/2014
15/12/2014
16/12/2014
17/12/2014
Want to retrieve this. I have an idea indirect fu
Are you looking for an Excel Function or VBA solution?
In Excel, dates are stored as numbers.
(The number of days since 1/1/1900)
So:
12/12/2014 is 41985
12/22/2014 is 41995
So, the number of days between two dates is found by subtracting the two
dates.
In VBA, there is the DateDiff() functi
Another one;
=INT((WEEKDAY(A1-*1*)+B1-A1)/7)
Note: There are 2 opening brackets before WEEKDAY.
A1 = Start_Date
B1 = End_Date
*1* = Sun, *2* = Mon, *3* = Tue, *4* = Wed, *5* = Thu, *6* = Fri, *7* = Sat
If you want to count multiple days between 2 dates use then inside an Array
separated by co
Thank you! Worked like a charm!
On Oct 10, 1:27 pm, RockyFontane wrote:
> I am trying to count the number of Sunday's between two date ranges.
> For example, Start Date: 9/25/2011; End Date: 10/24/2011. The
> number of Sunday's between these two dates are 5. What's the best way
> to write th
