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,
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 & 64
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:
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
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:
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 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
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 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
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
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
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
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
>
>
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 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
Dear Ravinder
Thanks a lot. The formula seems so simple, if only i had used my head.
Again, thanks.
Regards,
Boreh
On 3 January 2014 13:01, Ravinder wrote:
> =IF(TEXT(date_rng,"ddd")="SAT",C60-1,IF((TEXT(date_rng,"ddd")="SUN"),date_rng-2,date_rng
> ))
>
> Or pfa
>
>
>
>
>
> *From:* excel-macr
=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: excel-macros
Subject: $$Excel-Macros$$ Date
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
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 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
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
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
Date: Sat, Jun 22, 2013 at 5:51 PM
> Subject: Re: $$Excel-Macros$$ Date format to be changed
> To: excel-macros@googlegroups.com
>
>
> Dear Pravin :
>
> Use the below
> =TEXT(DATE(RIGHT(B4,4),MID(B4,4,2),LEFT(B4,2)),"DD-MMM-")
>
>
> On Sat, Jun 22, 2013 at 3:
ere after long time..
>
> Regards
> Pravin Gunjal.
>
> -- Forwarded message --
> From: Ahmed Honest
> Date: Sat, Jun 22, 2013 at 5:51 PM
> Subject: Re: $$Excel-Macros$$ Date format to be changed
> To: excel-macros@googlegroups.com
>
>
> Dear Pravi
orwarded message --
> From: VBA VABZ
> Date: Sat, Jun 22, 2013 at 3:38 PM
> Subject: Re: $$Excel-Macros$$ Date format to be changed
> To: "excel-macros@googlegroups.com"
>
>
> Select cell, right click, format cell, custom & type DD--.
>
> You c
Select cell, right click, format cell, custom & type DD--.
You can use text(cell,"DD-MMM-") also.
Thanks
On Sat, Jun 22, 2013 at 1:31 PM, Pravin Gunjal wrote:
> I have date in this format : *DD.MM.* (with dot) and require it as : *
> DD-MMM-* (with hyphen).
> For example :
Please find attached
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Pravin Gunjal
Sent: 14 June 2013 12:10
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Date conversion to other format
Hi,
I want to convert the date =Today() to
refer..
On Fri, Jun 14, 2013 at 12:10 PM, Pravin Gunjal wrote:
> Hi,
>
> I want to convert the date =Today() to this format : DD.MM.
>
> Formula =Today() 6/14/2013 In next cell, it should display as :
> 14.06.2013
> Sample file is attached. Thanks.
>
> Regards
> Pravin Gunnjal
>
> --
>
Dear Pravin
try it
=TEXT(TODAY(),"dd.mm.")
or
select cell and press ctrl+1 and type in custom format dd.mm.
On Fri, Jun 14, 2013 at 12:10 PM, Pravin Gunjal wrote:
> Hi,
>
> I want to convert the date =Today() to this format : DD.MM.
>
> Formula =Today() 6/14/2013 In next cel
3 at 4:43 PM, Pravin Gunjal wrote:
>
>> *Thanks everyone.
>> *
>>
>> -- Forwarded message ------
>> From: अनिल नारायण गवली
>> Date: Tue, Apr 9, 2013 at 4:42 PM
>> Subject: Re: $$Excel-Macros$$ Date to Month formula
>> To: "excel-macro
=TEXT(D3,"-")
Drag down.
On Tue, Apr 9, 2013 at 4:35 PM, Pravin Gunjal wrote:
> Hi, I would like to convert the date in to the month & year format as
> follows/attached file.
>
> *Now* *Result* *DATE* *MONTH-YEAR* 7-Apr-12 April-2012 17-Apr-12
> April-2012 25-Apr-12 April-2012 2
Hi Excel Beginner,
Thank you for posting the conversion file from Gregorian into Hijri.
Do you mind sharing the formula to make it the other way, i.e. from Hijri
into Gregorian please?!
Many thanks!
Ziad
On Tuesday, September 25, 2012 1:15:05 PM UTC-4, Excel Beginner wrote:
>
> Hi Ahmed,
>
o all the people you can,
As long as ever you can.” - John Wesley
-
From: David Grugeon
To: "excel-macros@googlegroups.com"
Sent: Fri, February 22, 2013 7:23:40 AM
Subject: Re: $$Excel-Macros$$ Date hour valu
long as ever you can.” - John Wesley
-
From: David Grugeon
To: "excel-macros@googlegroups.com"
Sent: Fri, February 22, 2013 7:23:40 AM
Subject: Re: $$Excel-Macros$$ Date hour value problem!
OK
A date/
rting it become 2:03. Don't know why! Pls suggest!
>>>
>>>
>>> Sandeep Chhajer.
>>> Sent on my BlackBerry® from Vodafone
>>> --
>>> *From: * The Viper
>>> *Sender: * excel-macros@googlegroups.com
>>> *
@googlegroups.com
Subject: Re: $$Excel-Macros$$ Date hour value problem!
try this
If the value is in B3 use then formula
=(int(B3)+mod(B3,1)/.6)/24
then format as h:mm
Regards
David Grugeon
On 22 February 2013 20:36, The Viper wrote:
> excel will not hold a value as 2.30 with full decima
22 Feb 2013 15:48:08 +0530
>> *To: *
>> *ReplyTo: * excel-macros@googlegroups.com
>> *Subject: *Re: $$Excel-Macros$$ Date hour value problem!
>>
>> select the data and press ctrl+h
>> put .(dot) in "Find what" and put ":" in "Replace with&
excel-macros@googlegroups.com
> *Date: *Fri, 22 Feb 2013 15:48:08 +0530
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ Date hour value problem!
>
> select the data and press ctrl+h
> put .(dot) in "Find what" and put ":&
ssage-
From: The Viper
Sender: excel-macros@googlegroups.com
Date: Fri, 22 Feb 2013 15:48:08
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Date hour value problem!
select the data and press ctrl+h
put .(dot) in "Find what" and put ":" in "R
select the data and press ctrl+h
put .(dot) in "Find what" and put ":" in "Replace with"
click Replace all
On Fri, Feb 22, 2013 at 3:41 PM, wrote:
> Dear excel guru,
> I have a problem...I want my hour to be written as 4:45. But I entered
> 2 data as 4.45. Now if I am changing it to [h]:mm f
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: Kuldeep Singh
To: excel-macros@googlegroups.com
Sent: Thu, February 21, 2013 5:31:24 A
are you working with real date or text?
if you r working with text then try the below
=(DATE(RIGHT(A1,4),MID(A1,4,2),LEFT(A1,2)))+7
or
=TEXT((DATE(RIGHT(A1,4),MID(A1,4,2),LEFT(A1,2)))+7,"DD/MM/)
On Thu, Feb 21, 2013 at 4:01 PM, Kuldeep Singh wrote:
>
> I am already try this =A1+7. this is n
I am already try this =A1+7. this is not working. because date format is
dd/mm/
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-0120-4841100, Extn.: 2467, 9716615535
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-
assuming your date is in a1
=a1+7
On Thu, Feb 21, 2013 at 3:52 PM, Kuldeep Singh wrote:
>
> Hi All,
>
> One instant query. my format is 18/02/2013 & I want to add 7 days. Please
> help
>
> Regards,
> Kuldeep Singh
> Info Edge India Limited (naukri.com)
> Phone.: +91-0120-4841100, Extn.: 2467,
It really depends on what you want to do with the result.
Keep in mind that to Excel, any "date" is really just a number.
That is: The number of days since 1/1/1900.
and TIME, is really the fractional part of a day.
So, today, January 7, 2013 at 9:45:33am is: 41281.406633680600
You can find the
what u want to find .. hours , or minutes ,
On Mon, Jan 7, 2013 at 7:50 PM, Nitesh Sharma
wrote:
> Hi all,
> need your help
>
> i need a vba code which able to subtract user given DateTime in any
> cell(say a1 = 07-01-2012 19:44) with the current system time.
>
> --
> Join official Facebook pag
1 - 100 of 244 matches
Mail list logo