*Hi Rakesh *
*
*
*You may use this following formula.*
*
*
*"B2" is a cell address suppose to be a cell of birth date.
*
*
*
*="Age is "&DATEDIF(B2,TODAY(),"y")&" Years, "&DATEDIF(B2,TODAY(),"ym")&"
Months and "&DATEDIF(B2,TODAY(),"md")&" Days"*
*
*
*Regards*
*Pravin.*
-- Forwarded message
Thanks David , Attached file
Date: Fri, 7 Dec 2012 09:15:36 +1000
Subject: Re: $$Excel-Macros$$ Re: Lease date alarm
From: da...@grugeon.com.au
To: excel-macros@googlegroups.com
Hi Ahmed
If you want more help you will have to give us more information. It is not
helpful to just say "It did not
Hi,
there is Datedif() function can be used for calculating age
=datedif(DOB,today(),"Y") for years=datedif(DOB,Today(),"YM" ) for
months=datedif(DOB,today(), "MD") for days
--- On Fri, 12/7/12, Rakesh Kumar Sharma wrote:
From: Rakesh Kumar Sharma
Subject: $$Excel-Macros$$ Formula to Calculat
Hi Satyas,
Do you want to know the count of the persons of on booth1, booth2 and so
on or somthing else please help us to know your exact requirement so that
we can assist you in this regards.
Regard
Prince
On Friday, December 7, 2012 4:06:27 AM UTC+5:30, satyas wrote:
>
> Need to create a
Dear Gurus,
Please help me to count no of students for each month
For example :
july 6 students
Thanks
N.Sundarvelan
9600160150
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like P
Dear Expert,
Looking forward for the below humble request
Thanks
Manjunath
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Manjunath Narayanappa
Sent: 06 December 2012 14:51
To: 'excel-macros@googlegroups.com'
Cc: 'schreiner_p...@att.net'
Subject: $$Exce
PFA
Thanks,
On Fri, Dec 7, 2012 at 3:45 AM, Sundarvelan N wrote:
> Dear Gurus,
>
> Please help me to count no of students for each month
>
> For example :
>
> july 6 students
> Thanks
> N.Sundarvelan
> 9600160150
>
> --
> Join official Facebook page of this forum @
> https://www.facebook.c
I'm afraid that =Weeknum() isn't quite what he'd want in this case.
It would work as long as the "Future Date" is in the same year
as today().
But doesn't work if the year of the "future date" is not the current year.
=weeknum() gives the "week number" of the year in the date.
That is, if your
Thaks for your reply
But i need 6 for July
Unique value.
Thanks
N.Sundarvelan
9600160150
On Fri, Dec 7, 2012 at 5:48 PM, Born to Win wrote:
> PFA
>
>
> Thanks,
>
>
>
>
>
> On Fri, Dec 7, 2012 at 3:45 AM, Sundarvelan N wrote:
>
>> Dear Gurus,
>>
>> Please help me to count no of students for
I'm sorry.
You haven't answered my question(s).
WHERE is it asking for a password?
when you open the file: "path1"?
when you select the "Data" sheet?
when you open the file: "path2"?
when you save the file as "path3"?
when you select the "Control_Panel" sheet?
when you select the "Result" sheet?
Wow! OK, let's see what we can do. Going with your most recent post first:
I tried running the ReadData first pass on the real output. I got an error:
"Run-time error '9': Subscript out of range". When I chose "debug," the code
that was highlighed was Ln 41, Col 1:
Sheets(Sht_Out).Range("A2:Z
Exactly Prince I need the count of the persons of on booth1, booth 2 and so
on.
On Friday, December 7, 2012 4:06:27 AM UTC+5:30, satyas wrote:
>
> Need to create a summary sheet for the attached Excel doc.
>
> Tab “Detailed” is the input tab and works fine.
>
> Tab “Summary” should show the name
On Fri, Dec 7, 2012 at 10:31 PM, nm wrote:
>Hi,
> suppose todays date is 1st jan 2012. and i want get some data after
> 10working days (there are holidays in between). for eg: the date after 10
> working days is 21st jan 12. i am not able to do simply by " 1jan12 + 10 ".
> what is the formula
but i cant share a document to you. if using dos is this possible.
Thanks
Manoj
On 12/6/12, Paul Schreiner wrote:
> There IS a way to get to the data in an excel file without opening it,
> but I've not worked with that much.
> Mainly because it's very convenient to simply have Excel disable disp
Dear Surder,
are you need like attached.
On Fri, Dec 7, 2012 at 7:31 PM, Sundarvelan N wrote:
> Thaks for your reply
>
> But i need 6 for July
>
> Unique value.
> Thanks
> N.Sundarvelan
> 9600160150
>
>
>
> On Fri, Dec 7, 2012 at 5:48 PM, Born to Win wrote:
>
>> PFA
>>
>>
>> Thanks,
>>
>>
>>
>
Hi Anoop
Thanks very much for solution but I want neutral arrow is horizontal not
vertical.
On Fri, Dec 7, 2012 at 12:56 PM, Anoop K Sharma wrote:
> =IF(B2>$A$2,"↓",IF(B2<$A$2,"↑","↕"))
>
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use
Dear champs,
i need help create a macro any report & after pivot i have to click command
button to generate the report.
plz help me
need full
--
Regards,
Shivaprasad K.
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, ac
Hi,
Search in google about MODI OR OCR in VBA
Or check below link
www.ozgrid.com/forum/showthread.php?t=147473
Sent from my iPhone
On Dec 6, 2012, at 11:43 PM, "Indrajit $nai" wrote:
> Hi All,
>
> Is it possible to convert a Bitmap image (BMP) into a Excel file through some
> Macro?
>
>
Hi Nik,
Please try this attached sheet and advise whether you exactly want this or else.
--- On Fri, 12/7/12, nm wrote:
From: nm
Subject: $$Excel-Macros$$ Re: Pl Solve my date query
To: excel-macros@googlegroups.com
Date: Friday, December 7, 2012, 10:55 PM
On Fri, Dec 7, 2012 at 10:31 PM,
Dear Sir
If I write any name in main sheet excel create new sheet in the excel with
all the columns and rows like earlier sheet with formula's. How can i do
this.
--
*Rajesh Kumar Agarwal*
*9811063001*
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM
Hi Indrajit,
Try from this link : http://www.onlineocr.net/
Thanks
Karan
Karan Singh
On Sat, Dec 8, 2012 at 12:08 PM, XLS S wrote:
> Hi,
>
> Search in google about MODI OR OCR in VBA
>
> Or check below link
>
> www.ozgrid.com/forum/showthread.php?t=147473
>
> Sent from my iPhone
>
> On D
21 matches
Mail list logo
