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()
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
Sir,
Check this
[image: Inline image 1]
On Fri, Dec 12, 2014 at 6:07 PM, Mandeep Baluja rockerna...@gmail.com
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
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
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 Baluja rockerna...@gmail.com
To: excel-macros@googlegroups.com
Sent: Friday, December 12, 2014 7:37 AM
Subject: $$Excel-Macros$$ Re
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
B1
12/22/2014
Formula should return in number of rows.
C1,c2,c3,c4,c5
want this Broo
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
Thank you! Worked like a charm!
On Oct 10, 1:27 pm, RockyFontane vtorral...@gmail.com 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
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