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
You could use Data Validation to create a selection list.
See attached.
Paul
-
“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 c
Hi Gurus,
I have a very simple spreadsheet that calculates an account payoff. A
percentage amount is applied to calculate the total due depending on one of
the 3 values..
the spreadsheet works as is but is not very elegant.
All help would be greatly appreciated.
--
Are you =EXP(E:RT) or =N
Just like put a string inside a day box, for each day in the excel sheet,
where ever "test" columns have some entries.
Eugene
On Fri, Dec 12, 2014 at 10:27 PM, Vaibhav Joshi wrote:
>
> Is it appointment? What is start time? Duration?
>
> Check this helps:
> http://www.mrexcel.com/forum/excel-que
http://www.slipstick.com/developer/create-appointments-spreadsheet-data/
+
*I did not do this for you. God is here working through me for you.*
On Fri, Dec 12, 2014 at 10:27 PM, Vaibhav Joshi wrote:
>
> Is it appointment? What is start time? Duration?
>
> Check this helps:
> http://www.mrexc
Is it appointment? What is start time? Duration?
Check this helps:
http://www.mrexcel.com/forum/excel-questions/553718-excel-visual-basic-applications-update-create-delete-appointments.html
+
*I did not do this for you. God is here working through me for you.*
On Fri, Dec 12, 2014 at 9:52 PM
I like to put the strings from the column "test" of attached excel file in
the Outlook calander (month format), based on date values. Is it possible.
TIA
Eugene
--
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
OK, I read your question.. all of them.
and have NO idea what you're asking for.
The problem here is that you have a worksheet in front of you that has stuff on
it.
I have a blank worksheet.
The ONLY thing I can put on the sheet is what you tell me.
You said you wanted the NUMBER of dates
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
OK, a couple of things:
You're changing date formats. (just so you know)
12/22/2014 is mm/dd/ format
13/12/2014 is dd/mm/ format.
Now, it's entirely POSSIBLE to do that, but unusual.
Second, my questions still remains.
Are you looking for Excel functions, or VBA?
Again, remember t
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/
Very nice Sir
i checked some diff files
but not correctly working
than i use microsoft Save as Pdf
its good than that
bcoz all systems not installed that one
i am using this now
thank you sir
On 12 December 2014 at 17:48, Paul Schreiner wrote:
>
> A Third Party software is no longer required wi
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
I could not find a method to display two columns in the pull-down while
only showing (3) characters in the cell.
So, I went with creating a double-click event.
In the event, I displayed a userform with a two-column combobox and
selected the listindex matching the current contents of the cell.
I
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
A Third Party software is no longer required with the newer versions of Excel!
I think beginning with Excel 2007 (DEFINITELY available in Excel 2010)
simply hide the sheets you don't want in the PDF,
hide or filter out the rows you don't want to display,
and do a File->Save As
and select the PDF fi
Just for knowledge can we get the number *Dates* between two dates. I am
trying to achieve with array. I saw it somewhere just slipped out of my
mind.
For example
Start date
12/12/2014
end date
12/22/2014
Return me number of Dates between two dates. 10 days should be shown in
number of row
Now there is no need to buy third party software...
Using VBA you can convert excel sheets or WB to pdf on the go..
Refer below code for one of such example:
Sub PDFActiveSheet()
Dim ws As Worksheet
Dim strPath As String
Dim myFile As Variant
Dim strFile As String
On Error GoTo errHandler
Set w
This is very genuine problem with the user's of excel as i often need to
transfer many excel files to one PDF file . It is really time consuming
process if we need to convert multiple sheets to one PDF manually . Better
solution for this problem is to use excel converter tool. I have been using
hi
You will get error if no value is added in list box.
add line "on error resume next" in beginning to avoid this error..
cheers
+
*I did not do this for you. God is here working through me for you.*
On Fri, Dec 12, 2014 at 1:03 AM, Rob Flott wrote:
>
> On a worksheet I have two listboxe
21 matches
Mail list logo
