Any Solution?
On Mon, Apr 30, 2018 at 7:29 PM, amar takale wrote:
>
> --
> 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 forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, acc
Is there a reason you need a "code with loop"?I take it you want it in VBA?It's
really the same process as the formula I gave you.
The loop is:Dim nRow as integerFor nRow = 2 to 57...Next nRow In the loop, you
test to see if the value in column A of the current row is not blank.Instead
of:IF(A2<
How do I draft it in code with loop ... please help !!!
On Tue, Oct 10, 2017 at 6:45 PM, Paul Schreiner
wrote:
> You could use a simple formula in column B, starting in B2 with:
> =IF(A2<>"",A2,B1+1)
>
> and copied down.
>
> Excel automatically calculates the next date and considers leap years w
You could use a simple formula in column B, starting in B2
with:=IF(A2<>"",A2,B1+1)
and copied down.
Excel automatically calculates the next date and considers leap years when
doing so. Paul-
“Do all the good you can,
By all the means you can,
In all the wa
Hi Team,
I have enclosed the excel file - Sheet1 for your reference.
1. I need the day , month and year to be generated continuously until the
next cell which has the date in it and so on and so forth
2.The leap year has to be checked prior to the increment.
--
With Regards,
Rathi Alageshu.
-
Hi,
Anyone can you help me on this?
Regards,
Chandru
Sent from my Samsung Galaxy smartphone.
Original message From: Chandra Shekar
Date: 15/01/2017 5:53 p.m. (GMT+05:30) To:
excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Date & Time picker in
Excel 2010 - 32
Hello Team,
Is there anyway to add Date & Time picker in Excel 2010 in both 32 & 64 bit
system.
I tried in 32 bit system its working fine but not same with 64 bit system.
Can someone help me out on this.
Regards,
Chandrashekar B
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
I did this (custom formatting) in my computer but not working, actually I
got this file from a system where the date format of the system was
mm/dd/
--
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 forum
Just change custom formatting --
Select data range
right click
go to format cell
go to customer in number tab
paste this - dd/mm/
[image: Inline image 1]
On Mon, Jul 11, 2016 at 10:54 AM, Izhar wrote:
> Please open the file, I've given everything in the attach file
>
> --
> Are you =EXP(E:
Please open the file, I've given everything in the attach file
--
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 forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread title
Hi,
PSA.
Column "A" = source.date.
Column "B" = source date converted to special date form MMDD
I would like column "C" to be just the numeric. .
I have tried just about everything.
Cannot figure this out.
Any takers ?
Much appreciated.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in
Here's a macro to delete records by date.
The Technique:Since I didn't know how many records you have or dates to
process,I elected to store the dates in a Dictionary Object.This makes it VERY
fast to verify if the dates in the records are included in the Deletion list.
I then processed the recor
Hi Experts,
can some one please advise me the process or code to delete the records
from sheet 2 and specified dates in sheet 1 criteria .
i am attaching sample data please advise me how to use vba macros in this
regards.
Thanks for your help.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel
Dear Mandeep
Very Helpful and thanks providing this helpful knowledge regarding date
solution.
And Thank you very much for all
Regards
Amar
On Mon, Feb 8, 2016 at 3:06 PM, Mandeep baluja
wrote:
> Hey Amar,
>>
>
> While doing manipulations with date you must ensure the Format of System
>
> Hey Amar,
>
While doing manipulations with date you must ensure the Format of System
date format.Some people use mm/dd/ and others use dd/mm/ so if
someone has provide you the data in his format and you'r date format is
different from that it will shows you the error.
Note one t
Dear all thanks for reply but i cant understand what you say.I except only
date formula in column D.
On Sun, Feb 7, 2016 at 9:36 PM, GENIUS wrote:
> LOOK AT THE ATTACHMENT
>
> --
> 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 Fac
LOOK AT THE ATTACHMENT
--
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 forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
This is 1 st time i am sending other query's reply.
Otherwise i am always sending query only.
Thank you very much
Check this file too. It may also help you & our group too ..
You can add days also in today' s date
If u think to have some more correction & then let me know
On 6 February 2016
Look at the second name "Carme" in your sheet.
Your formula is picking up the first 02 digits of the DOB and taking them
as 'month' and there is no 16th month in the calender.
You either need to change your formula or the dates themselves.
HTH
On Sat, Feb 6, 2016 at 2:50 PM, amar takale wrote:
Dear All
Here I required Date formula for Age Calculation but in cell date there are
some issue Value or text cell format,I cant understand. pls look matter,i
try it helper column but some date issue again.
Pls provide Date formula without helper column
Regards
Amar
--
Are you =EXP(E:RT) or =N
PSA.
Can someone please create a macro for me that would eliminate this
frustrating problem that I have with date converstion.
DATE1 = Source. It always gets imported in as 2 different date formats.
DATE2 is what I want returned in a MMDD format. I have manually change
it in this exampl
Hi Sumesh
Please see the attached file. It has both conversions.
On Tue, Apr 28, 2015 at 11:14 AM, Sumesh Nair wrote:
> Hi Excel Beginner,
>
> I want your help in converting the date in two columns in Excel.
>
> If in one column(A1) I will enter Hijri Date the next column(B1) should be
> change
Hi Excel Beginner,
I want your help in converting the date in two columns in Excel.
If in one column(A1) I will enter Hijri Date the next column(B1) should be
changed to English date.
Please help me to solve this problem
Thanks & Regards,
Sumesh Nair
On Tuesday, September 25, 2012 at 8:15:
This time code is working ok, what exactly you want please share in Excel
Sheet..
On Thu, Feb 5, 2015 at 8:35 PM, Vaibhav Joshi wrote:
> Check this on how to disable close button:
>
> http://www.vbaexpress.com/kb/getarticle.php?kb_id=164
>
> http://www.contextures.com/xlUserForm01.html
>
> Cheer
Check this on how to disable close button:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=164
http://www.contextures.com/xlUserForm01.html
Cheers!!
On Mon, Feb 2, 2015 at 7:11 AM, sswcharlie wrote:
> Hi
> Excel 2000
> Three small questions as to these small codes not working.
>
> Want to
Hi
Use following code for creating Index:
Worksheet Index
First add a new sheet to the Workbook and call it "Index" (optional).
Next right click on the sheet name tab of the "Index" sheet and select
"View Code". In here you should paste the code as shown below
Private Sub Worksheet_Activate()
It's working Superb
Vaibhav Bhai you are Great!!!
--
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 forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor
Mon, 2 Feb 2015 12:59:48 +0530
>
> Subject: Re: $$Excel-Macros$$ Date Filters in Pivot Table Report Filter in
> VBA
> To: excel-macros@googlegroups.com
>
> Hi
>
> Code amended..
>
> Check Attachment,
>
> Cheers!!
>
> On Mon, Feb 2, 2015 at 2:39 AM, N
Thanks Vaibhav, it worked. This group is really amazing. Thanks for your
support and help.
Thanks and Regards,
Nitin Balodi
From: v...@vabs.in
Date: Mon, 2 Feb 2015 12:59:48 +0530
Subject: Re: $$Excel-Macros$$ Date Filters in Pivot Table Report Filter in VBA
To: excel-macros@googlegroups.com
Hi
@vabs.in
> Date: Sat, 31 Jan 2015 20:07:02 +0530
>
> Subject: Re: $$Excel-Macros$$ Date Filters in Pivot Table Report Filter in
> VBA
> To: excel-macros@googlegroups.com
>
> Hi
>
> Share sample chart..
>
>
>
> On Fri, Jan 30, 2015 at 8:32 PM, Nitin Balodi
>
Hi
Excel 2000
Three small questions as to these small codes not working.
Want to make a new sheet and list all sheets with hyperlink to each sheet.
Code curteosy of member of this group. (slips my mind at the moment apologies)
Sub MakeHyperlinkIndex()
Dim ndx As Worksheet, X As Integer
Set n
Hi Vaibhav,
Attached is the sample data file.
Regards.
Yours Sincerely,Nitin Balodi
From: v...@vabs.in
Date: Sat, 31 Jan 2015 20:07:02 +0530
Subject: Re: $$Excel-Macros$$ Date Filters in Pivot Table Report Filter in VBA
To: excel-macros@googlegroups.com
Hi
Share sample chart..
On Fri, Jan 30
d to include sheet name
> also, but of no use (getting type mismatch error).
>
> Regards.
>
> Yours Sincerely,
> *Nitin Balodi*
>
>
> --
> From: v...@vabs.in
> Date: Fri, 30 Jan 2015 18:18:09 +0530
>
> Subject: Re: $$Excel-Macros$$
,Nitin Balodi
From: v...@vabs.in
Date: Fri, 30 Jan 2015 18:18:09 +0530
Subject: Re: $$Excel-Macros$$ Date Filters in Pivot Table Report Filter in VBA
To: excel-macros@googlegroups.com
try
Charts("Chart1").SetSourceData Source:=application.union(Range1,Range2)
Cheers!!ᐧ
On Fri, Jan 30, 20
quot; &
> EndRow, Range2)
>
>
> Regards.
>
> Yours Sincerely,
> *Nitin Balodi*
>
>
> --
> From: v...@vabs.in
> Date: Thu, 29 Jan 2015 21:53:29 +0530
>
> Subject: Re: $$Excel-Macros$$ Date Filters in Pivot Table Report Filter in
>
urce:=Range("A" & StartRow & ":B" & EndRow,
Range2)
Regards.
Yours Sincerely,Nitin Balodi
From: v...@vabs.in
Date: Thu, 29 Jan 2015 21:53:29 +0530
Subject: Re: $$Excel-Macros$$ Date Filters in Pivot Table Report Filter in VBA
To: excel-macros@googlegroups.com
check t
:( and yes the sheet name is Pivot and
> Pivot Table name is PivotTable1.
>
>
> Regards.
>
> Yours Sincerely,
> *Nitin Balodi*
>
>
> --
> From: v...@vabs.in
> Date: Tue, 27 Jan 2015 21:07:40 +0530
> Subject: Re: $$Excel-Macros$$ Date Fil
Balodi
From: v...@vabs.in
Date: Tue, 27 Jan 2015 21:07:40 +0530
Subject: Re: $$Excel-Macros$$ Date Filters in Pivot Table Report Filter in VBA
To: excel-macros@googlegroups.com
there is workaround..try bellow code..
Sub abc()Dim Field As PivotField, fDateSet Field =
Sheets("Pivot").P
Balodi
From: v...@vabs.in
Date: Tue, 27 Jan 2015 21:07:40 +0530
Subject: Re: $$Excel-Macros$$ Date Filters in Pivot Table Report Filter in VBA
To: excel-macros@googlegroups.com
there is workaround..try bellow code..
Sub abc()Dim Field As PivotField, fDateSet Field =
Sheets("Pivot").P
ed error.
>>
>>
>> Regards.
>>
>> Yours Sincerely,
>> *Nitin Balodi*
>>
>>
>> --
>> From: v...@vabs.in
>> Date: Tue, 27 Jan 2015 16:50:17 +0530
>> Subject: Re: $$Excel-Macros$$ Date Filters in Pivot T
> Date: Tue, 27 Jan 2015 16:50:17 +0530
> Subject: Re: $$Excel-Macros$$ Date Filters in Pivot Table Report Filter in
> VBA
> To: excel-macros@googlegroups.com
>
>
> Instead of ActiveSheet you can also use:
>
> Sheets("Pivot").PivotTables("PivotTable1")
Hi Vaibhav,
Thanks for your response. I have tried code you had suggested but it showing me
object defined or application defined error.
Regards.
Yours Sincerely,Nitin Balodi
From: v...@vabs.in
Date: Tue, 27 Jan 2015 16:50:17 +0530
Subject: Re: $$Excel-Macros$$ Date Filters in Pivot Table
Instead of ActiveSheet you can also use:
Sheets("Pivot").PivotTables("PivotTable1").PivotFields("Created
Date").CurrentPage _
= #1/25/2015#
ᐧ
On Tue, Jan 27, 2015 at 4:48 PM, Vaibhav Joshi wrote:
> Hi
>
> Since it is report filter your method wont work..
>
> you can try replacing last l
Hi
Since it is report filter your method wont work..
you can try replacing last line with with following two or last one only...
Sheets("Pivot").PivotTables("PivotTable1").ClearAllFilters
ActiveSheet.PivotTables("PivotTable1").PivotFields("Created
Date").CurrentPage _
= #1/23/2015#
Chee
Hi Experts,
I am having some issues in filtering data in pivot tables and require your
help. I have to filter all the data of yesterday date in pivot table. I have
added Created Date column to Page Field using VBA but unable to filter out data
with Create date of yesterday. Please refer to attac
Hi
VBA considering it as mdy format..
Use format function to switch format..
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Mon, Dec 29, 2014 at 3:01 PM, saravanan R wrote:
> Hi Team,
>
> I have an query on replace "." with "/" in the Data pulled from
Hi Team,
I have an query on replace "." with "/" in the Data pulled from SAP .
Actually Format is,
01.12.2014 17.12.2014 WHen I Do Manually Find & Replace,
It show me as ,
1/Dec/14
17/Dec/14.
But when I do through VBA COde,
I replace as,
12/Jan/14
"INVALID DATE FORMAT)
Can You please check in
Hi Ashish,
PFA
Regards
Ashish
--
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 forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Pl
Dear experts,
I have series of date in which only sunday should be highlighted, please
see attached file for example.
Regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*
--
Are you =EXP(E:RT) or =NOT(EXP(E:R
see this...
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Fri, Sep 12, 2014 at 1:44 PM, Ashish Bhalara
wrote:
> Dear experts,
>
> I am using Concatinate function to merge different text but date field not
> shown as a date in function. Kindly suggest r
Dear experts,
I am using Concatinate function to merge different text but date field not
shown as a date in function. Kindly suggest require changes to merge text
and date.
See the attached file.
Regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessar
In Cell (C5:Z13) type: NN (Think 1 day), N (Think again day), Y (Dates of
Rest) to see results
2014-08-03 14:17 GMT+07:00 Rajeev :
> Dear Experts,
>
>
>
> I need help that in my worksheet Where I entered dates (Sheet1) in column
> A, in column B I have entered “Y” as working days and “N” as no
Dear Experts,
I need help that in my worksheet Where I entered dates (Sheet1) in column A,
in column B I have entered "Y" as working days and "N" as not working days.
Now I need in another sheet (sheet2) if I enter in A1 suppose any date it
should add 10 days excluding not working days and
This is working perfectly as per my requirement.
Thanks.
Regards
Pravin Gunjal.
On Sun, Jun 15, 2014 at 10:54 PM, 'DELIN FRANCIS' via MS EXCEL AND VBA
MACROS wrote:
> Hi Pravin ...
>
> You can go to Format cell and custom the format of the date which ever
> result you need. furthermore you can
ou
>> 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:* 'DELIN FRANCIS' via MS EXCEL AND VBA MACROS <
>> excel-macr
an,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:* 'DELIN FRANCIS' via MS EXCEL AND VBA MACROS <
> excel-macros@googlegroups.com>
>
can,
As long as ever you can.” - John Wesley
-
From: 'DELIN FRANCIS' via MS EXCEL AND VBA MACROS
>To: "excel-macros@googlegroups.com"
>Sent: Sunday, June 15, 2014 1:24 PM
>Subject: Re: $$Excel-Macros$$ Date Format Query
&g
Hi
You can change display format by going to cell property & select custom and
type dd.mm.
If by doing so if date format does not change then select single column
then press Data tab in Menu then press Next 2 times then select Date (DMY)
and press finish button.
Cheers!!
On Thu, Jun 12, 20
Where have not applying this date format.. Can send u file with mark
area
Pramod
On 14 Jun 2014 10:41, "Pravin Gunjal" wrote:
> Dear Pramod,
>
> Thank you for your reply. But I found it is not giving result for all
> cells.
> Please do the needful.
>
>
> On Thu, Jun 12, 2014 at 4:22 PM, Pra
Dear Pramod,
Thank you for your reply. But I found it is not giving result for all
cells.
Please do the needful.
On Thu, Jun 12, 2014 at 4:22 PM, Pramod Singh wrote:
> Hi
> Pravin Gunjal,
>
> PFA
>
> Hope This will fine for you..
>
>
>
>
> Warm Regards
>
> Pramod
>
> VBA Developer
>
>
> O
Hi
Pravin Gunjal,
PFA
Hope This will fine for you..
Warm Regards
Pramod
VBA Developer
On Thu, Jun 12, 2014 at 3:12 PM, Pravin Gunjal wrote:
> Hi,
>
> I wanted to convert the dates in this format *DD.MM.*
>
> Now it is not in system's date format ( MM/DD/ ) and it is displaye
Hi,
I wanted to convert the dates in this format *DD.MM.*
Now it is not in system's date format ( MM/DD/ ) and it is displayed as
DD/MM/ or as D/M/.
Kindly help.
Regards
Pravin Gunjal.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:I
Hello, Do I get any updates on this?
-- Forwarded message --
From: Pravin Gunjal
Date: Fri, Jun 6, 2014 at 6:01 PM
Subject: Date wise amount & Invoice Nos. wanted to merge
To: excel-macros@googlegroups.com
Dear Friends
Good Evening,
I have attached a working file and need help
Assuming data in cells a1 to e5
A6 cell value=
If(and(a2=a3,a2=a4,a2=a5),a2,"not same date"))
B5 cell value =
Sum (b2:b5)
C5 cell value=
C2&"/"c3&"/"&c4&"/"c5
Thanks & Regards
Hari Kumar
"Our strength grows from our weakness."
On Jun 6, 2014 8:31 AM, "Pravin Gunjal" wrote:
> Dear Friends
>
>
Dear Friends
Good Evening,
I have attached a working file and need help as follows:
1. The amount to be added in the above cell, if the date & party is unique.
2. Invoice No. to be added by giving slash (/)
For Example: Before Workout
*Due Date*
*Amount*
*Inv No*
*Party Name*
17.06.2014
Hi,
Use 'End of month' formula and add 720or whatever number of months to find
the date of retirement.(Usually retirement happens at the last day of the month)
- r.karunanithi.
On Wednesday, February 19, 2014 4:29 PM, "prabhakar_k...@sify.com"
wrote:
thanks its working fine
On Tuesday, Febr
thanks its working fine
On Tuesday, February 18, 2014 9:59:44 PM UTC+5:30, Mahesh wrote:
>
> Hi Prabhakar
>
> perhaps you can use,
> =DATE(YEAR(H2)+60,MONTH(H2),DAY(H2))
>
> Regards
> Mahesh
>
>
> On Tue, Feb 18, 2014 at 3:54 PM, Ashish Bhalara
>
> > wrote:
>
>> Dear Prabhakar, see the attached
Dear Mahesh
Good one
How to change date format.I want date format 5-Feb-2014.
Warm Regards
Amar
On Tue, Feb 18, 2014 at 9:35 PM, Mahesh Parab wrote:
> Hi Anil
>
> PFA workbook, you don't have to use calendar control.
>
> Regards
> Mahesh
>
>
> On Mon, Feb 17, 2014 at 4:46 PM, Swapnil Pala
Hi Prabhakar
perhaps you can use,
=DATE(YEAR(H2)+60,MONTH(H2),DAY(H2))
Regards
Mahesh
On Tue, Feb 18, 2014 at 3:54 PM, Ashish Bhalara
wrote:
> Dear Prabhakar, see the attached file to know the retire age as per your
> example
>
>
> On Tue, Feb 18, 2014 at 2:50 PM, wrote:
>
>> Hi Team,
>>
>> I
Dear Prabhakar, see the attached file to know the retire age as per your
example
On Tue, Feb 18, 2014 at 2:50 PM, wrote:
> Hi Team,
>
> I need your help to find out date of retirement with simple formula in
> attached excel file.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do y
Hi Team,
I need your help to find out date of retirement with simple formula in
attached excel file.
--
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 forum @
https://www.facebook.com/discussexcel
FORUM RUL
Hi Anil,
PFA.
Regards,
Swapnil.
On Mon, Feb 17, 2014 at 4:40 PM, Anil Bhange <
anil.bha...@tatacommunications.com> wrote:
> Hi Friends,
>
>
>
> Can you please share me the macro of Date picker or any sample file which
> I can use in excel to input the date.
>
>
>
> I seared on net but unfort
Hi Friends,
Can you please share me the macro of Date picker or any sample file which I can
use in excel to input the date.
I seared on net but unfortunately I don't have the "Microsoft Monthview Control
6.0 (SP6)" on my VBA.
Please help.
Regards, Anil Bhange
IP - 800105
--
Are you =EXP(E
g
> ))
>
> Or pfa
>
>
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Robinson Boreh
> *Sent:* Friday, January 03, 2014 3:25 PM
> *To:* excel-macros
> *Subject:* $$Excel-Macros$$ Date after weekend
>
>
&g
=IF(TEXT(date_rng,"ddd")="SAT",C60-1,IF((TEXT(date_rng,"ddd")="SUN"),
date_rng -2, date_rng))
Or pfa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Robinson Boreh
Sent: Friday, January 03, 2014 3:25 PM
To: exc
Dear team.
First happy new year.
I need help. I have a formula on my excel, to which i add a number of days
to give me a future date. My problem is, if the day falls on a weekend, it
should show the next working day in this case a date on Monday. How can i
achieve this. I don't want a date that fal
thanks to your replay
yes I am using this approach too ,but in some condition I need help in date
conversion
Thanks again...
Thanks & Regards, Rupesh
On Tue, Dec 3, 2013 at 11:07 PM, Sam Mathai Chacko wrote:
> Why don't you use a date picker? Better yet, a custom non-activex date
> picker?
>
Why don't you use a date picker? Better yet, a custom non-activex date
picker?
On Tue, Dec 3, 2013 at 10:46 PM, Rupesh Patil wrote:
> since long time i guess no buddy have solution for it
> thanks experts
>
>
> On Wed, Nov 27, 2013 at 9:43 AM, Rupesh Patil
> wrote:
>
>> Hi Expert
>>
>> I need a
since long time i guess no buddy have solution for it
thanks experts
On Wed, Nov 27, 2013 at 9:43 AM, Rupesh Patil wrote:
> Hi Expert
>
> I need a help for date conversion, let me explain my task, I have one
> userform with 10 multipage and each page have at list one date
> field(textbox), what
Dear Sam,
Thanks for reply
I want to substract from Column c To column B i e B-C,Forget about #N/A
Regards
Shrinivas
On Sun, Dec 1, 2013 at 10:11 PM, Sam Mathai Chacko wrote:
> Srini, are you looking to subtract dates in column C from column B or vice
> versa, ie, B-C or C-B? In addition, som
Srini, are you looking to subtract dates in column C from column B or vice
versa, ie, B-C or C-B? In addition, some values are coming as #N/A. What to
do with those?
Regards,
Sam Mathai Chacko
On Sun, Dec 1, 2013 at 3:57 PM, Shrinivas Shevde wrote:
> Dear all
> I want to subtract one date from
Dear all
I want to subtract one date from another (file attached )
Can anyone help me
I think for the date format is not same
Regards
Shrini
--
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 forum @
https://ww
Hi Expert
I need a help for date conversion, let me explain my task, I have one
userform with 10 multipage and each page have at list one date
field(textbox), what i want is user can enter whatever date format he want
but i want convert that format "DD-MMM-" so please help me out, How can
i do
Sir thanks for reply.
But sir... For Only few rows not get corrected.. Rest things are
perfects...why this so.
Regard,
Prafull Jadhav.
9920553518
On 19-Nov-2013 12:03 AM, "ashish koul" wrote:
> is it 1 apr 2013
>
> try to change the setting of ur computer control panel - regional setting
> -
is it 1 apr 2013
try to change the setting of ur computer control panel - regional setting
- choose English USA then try the macro
Regards
Ashish
On Mon, Nov 18, 2013 at 1:18 PM, Prafull Jadhav wrote:
> DEAR RAJAN SIR,
>
> thanks for reply...
> but output showing jan and feb month also afte
DEAR RAJAN SIR,
thanks for reply...
but output showing jan and feb month also after running macro .
Regards,
Prafull Jadhav
9920553518
On Mon, Nov 18, 2013 at 12:32 PM, Rajan sharma wrote:
> Hi, Try using below:
>
> Sub prafu()
> For Each x In Range("A1:A9000")
> x.Value = Format(x.Value
Hi, Try using below:
Sub prafu()
For Each x In Range("A1:A9000")
x.Value = Format(x.Value)
x.Value = Format(x.Value, "dd-mm- hh:mm")
Next x
End Sub
With warm regards,
Rajan Sharma
On Mon, Nov 18, 2013 at 12:23 PM, Prafull Jadhav
wrote:
> Dear All,
>
> Good Afternoon !
> I have on
please share ur vba code with example sheet
.
Enjoy
Team XLS
On Thu, Oct 10, 2013 at 6:39 AM, Viswanathan Yoganathan <
viswanathan.yoganat...@asia.xchanging.com> wrote:
> Hi,
>
> I am copying the date as text from one sheet and pasting to another sheet
> using the co
Hi,
I am copying the date as text from one sheet and pasting to another sheet using
the code activesheet.paste. when i do it so, it is converting to general number
41135.
after formatting to d/mm/, the date that is having greater than 12 get
converted exactly to d/mm/ where as date tha
Hi mum,
The 5 digit number is the equivalent value of the corresponding date in
that cell. You should see the correct format if you press CTRL+`
` is normally found just about the TAB key
Regards,
Sam Mathai Chacko
On Fri, Sep 20, 2013 at 8:31 PM, Dawn wrote:
> Hi!
> Im updating my skills in
Try To Press Button CTRL + ` (a button before button "1", in the top of
TAB button bellow the ESC ) :D
Or
Goto Menu Formula then deactivate Sub Menu "Show Formulas"
On 20-09-2013 22:01, Dawn wrote:
Hi!
Im updating my skills in excel and have created a spreadsheet with
heaps of dates in a col
Hi!
Im updating my skills in excel and have created a spreadsheet with heaps of
dates in a column. They have 'somehow' all changed to a five digit
number! The original date can still be seen in the text bar at the top but
doesn't appear in the cell. Ive tried to format the column back to a s
Dear Prabhakar,
It could be helpful.
please find solved attachment and confirm is it ok or not?
Regards,
Waseem Saifi
On Tue, Aug 6, 2013 at 10:52 AM, wrote:
> Dear Team,
>
> I have dates in different format and need to make it in one standard date
> format. Please help me to fix this.
>
> R
Dear Team,
I have dates in different format and need to make it in one standard date
format. Please help me to fix this.
Rgds,
Prabhakar
--
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 forum @
https://ww
thank u deepak its working
On Sat, Jul 27, 2013 at 12:09 AM, Deepak Barnwal wrote:
> PFA
>
> Regards
>
> deepak
>
>
> On Fri, Jul 26, 2013 at 11:28 PM, vba wrote:
>
>> PFA
>>
>> Actually years should be 37 & not 36!!
>>
>> HTH//Cheers
>>
>>
>> On Fri, Jul 26, 2013 at 10:12 AM, Shankar Bheema
>>
Friday of december to next year's last Thursday
of december.
Thanks in adv.
*From:* De Premor
*To:* excel-macros@googlegroups.com
*Sent:* Saturday, July 27, 2013 3:32 AM
*Subject:* Re: $$Excel-Macros$$ Date doubt
ans from 28 dec 2012 - 28march 2013, and 29 march 2013 to
27june 2013
half year means for eg : 28dec 2012 - 27june 2013, then 28 june 2013
to 26dec2013
yearly means 28dec2012 - 26dec 2013
any month starts from last Friday of the month and ends on last
Thursday of next month.
this is the pattern o
any month starts from last Friday of the month and ends on last
Thursday of next month.
this is the pattern of contracts followed in indian stock markets.
Pls find the file attched.
Thanks in adv.
--------
*From:* De Premor
*To
.
From: De Premor
To: excel-macros@googlegroups.com
Sent: Friday, July 26, 2013 6:40 AM
Subject: Re: $$Excel-Macros$$ Date doubt
First Approach
This function is to find first Friday on every given range, is this
match to your requirement ? if not, please reply
First Approach
This function is to find first Friday on every given range, is this
match to your requirement ? if not, please reply with data and date as
you want on each range.
Confuse on this statement "month from last Friday to last Thursday of
the month.", sample data needed.
Function fin
1 - 100 of 324 matches
Mail list logo
