Re: $$Excel-Macros$$ Dates

2014-12-12 Thread XLS S
let Start date in b2 and end date in b3 then in cell c2 =IF(($B$2+ROW(B1)-1)>$B$3,"",($B$2+ROW(B1)-1)) for very basic formula you can also use array or UDF if you want. . Enjoy Team XLS On Fri, Dec 12, 2014 at 5:48 PM, Mandeep Baluja wrote: > > Just for knowledge can

Re: $$Excel-Macros$$ Dates based on working hours

2013-06-25 Thread VBA VABZ
Pl consider this. On Tue, Jun 25, 2013 at 1:13 PM, VBA VABZ wrote: > See this sheet as per your requirements. > > Pl let us know if any error. > > HTH//Vabs > > > On Mon, Jun 24, 2013 at 8:14 PM, VBA VABZ wrote: > >> Hi >> >> Refer hope this will help. >> >> http://chandoo.org/wp/2010/09/10/wo

Re: $$Excel-Macros$$ Dates based on working hours

2013-06-25 Thread VBA VABZ
See this sheet as per your requirements. Pl let us know if any error. HTH//Vabs On Mon, Jun 24, 2013 at 8:14 PM, VBA VABZ wrote: > Hi > > Refer hope this will help. > > http://chandoo.org/wp/2010/09/10/working-hours-formula/ > > > Thanks > > > On Mon, Jun 24, 2013 at 7:18 PM, Chandra Shekar <

Re: $$Excel-Macros$$ Dates based on working hours

2013-06-24 Thread VBA VABZ
Hi Refer hope this will help. http://chandoo.org/wp/2010/09/10/working-hours-formula/ Thanks On Mon, Jun 24, 2013 at 7:18 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hi, > > Thanks for your reply its Date open & Date Close. > > Regards, > > Chandra > > On Mon, Jun 24, 2013 at

Re: $$Excel-Macros$$ Dates based on working hours

2013-06-24 Thread Chandra Shekar
Hi, Thanks for your reply its Date open & Date Close. Regards, Chandra On Mon, Jun 24, 2013 at 7:10 PM, VBA VABZ wrote: > HI > > Can you give more clarity. What date1 & date2 means here. > > Thanks > > > On Mon, Jun 24, 2013 at 6:22 PM, Chandra Shekar < > chandrashekarb@gmail.com> wrote:

Re: $$Excel-Macros$$ Dates based on working hours

2013-06-24 Thread VBA VABZ
HI Can you give more clarity. What date1 & date2 means here. Thanks On Mon, Jun 24, 2013 at 6:22 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hi, > > I need a formula which calculate dates based on working hours please find > attached file. > > Regards, > > Chandra > > > > -- >

Re: $$Excel-Macros$$ Dates In Excel

2011-10-10 Thread Sam Mathai Chacko
I was only saying that it would be easier for people to remember 1=Sunday, 2=Monday, 3=Tuesday etc, and that one can rely on the default return_type (which is 1) without actually having to pass it in the function. Makes the formula look more comprehensible. :) Also, in your example below, =SUMPROD

Re: $$Excel-Macros$$ Dates In Excel

2011-10-10 Thread NOORAIN ANSARI
Dear SAM, I am agree with your statement.. and thanks for your valuable advice.. But if we use formula with little bit correction then we can find monday, tuesday count. it works similar to your formula... For Monday =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A16&":"&A17)),1)<2)) For Tuesday =

Re: $$Excel-Macros$$ Dates In Excel

2011-10-10 Thread Sam Mathai Chacko
Hey Noorain, what's up :) Similar methods used, but, just to touch-base on the differences, what I made use of is the fact that the default return_type of the WEEKDAY function is 1, and it also means that the first day is expected as a Sunday. So in effect, if you equate the resultant array to any

Re: $$Excel-Macros$$ Dates In Excel

2011-10-10 Thread Sam Mathai Chacko
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)))=1)) Where A1 and B1 are your start dates, and 1=Sunday, 2=Monday, 3=Tuesday etc Regards, Sam Mathai Chacko (GL) On Mon, Oct 10, 2011 at 10:57 PM, RockyFontane wrote: > I am trying to count the number of Sunday's between two date ranges. > For e

Re: $$Excel-Macros$$ Dates In Excel

2011-10-10 Thread NOORAIN ANSARI
Dear Rocky, Please try it..and see attached sheet.. *=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(C3&":"&D3)),2)>6)) *-- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ Dates in Excel

2011-05-27 Thread hanumant shinde
Just replace the year from 2011 to 2010. by using replace all - Original Message > From: Rich Prince > To: MS EXCEL AND VBA MACROS > Sent: Thu, 26 May, 2011 6:49:10 PM > Subject: $$Excel-Macros$$ Dates in Excel > > I have a column of various dates that have the incorrect year, for >

Re: $$Excel-Macros$$ Dates in Excel

2011-05-26 Thread Shreedar Pandurangaiah
Hi, You can select all the dates and use Control + H Find What: 2011 Replace With: 2010 then click on Replace All button. It will change all the 2011 to 2010 Hope this helps! Thanks, Shreedar On Thu, May 26, 2011 at 11:19 PM, Rich Prince wrote: > I have a column of various dates that have the

Re: $$Excel-Macros$$ Dates in Excel

2011-05-26 Thread STDEV(i)
Assuming that you r date is in Cell A1 Convert them with this formula: Formula in B1=Date(2010,Month(A1),Day(A1)) On Fri, May 27, 2011 at 12:49 AM, Rich Prince wrote: > I have a column of various dates that have the incorrect year, for > example: > > 9/1/2011 > 12/17/2011 > 10/31/2011 >