*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 --
From:
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 rakeshks@gmail.com wrote:
From: Rakesh Kumar Sharma rakeshks@gmail.com
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
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:
PFA
Thanks,
On Fri, Dec 7, 2012 at 3:45 AM, Sundarvelan N nsund...@gmail.com 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 @
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 week
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 cs4...@gmail.com wrote:
PFA
Thanks,
On Fri, Dec 7, 2012 at 3:45 AM, Sundarvelan N nsund...@gmail.com wrote:
Dear Gurus,
Please help me to count
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?
when you
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:
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 from
On Fri, Dec 7, 2012 at 10:31 PM, nm nms8...@gmail.com 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
but i cant share a document to you. if using dos is this possible.
Thanks
Manoj
On 12/6/12, Paul Schreiner schreiner_p...@att.net 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
Dear Surder,
are you need like attached.
On Fri, Dec 7, 2012 at 7:31 PM, Sundarvelan N nsund...@gmail.com 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 cs4...@gmail.com wrote:
PFA
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 aks.sharm...@gmail.comwrote:
=IF(B2$A$2,↓,IF(B2$A$2,↑,↕))
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM
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,
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 talk2indra...@gmail.com wrote:
Hi All,
Is it possible to convert a Bitmap image (BMP) into a Excel file through
Hi Nik,
Please try this attached sheet and advise whether you exactly want this or else.
--- On Fri, 12/7/12, nm nms8...@gmail.com wrote:
From: nm nms8...@gmail.com
Subject: $$Excel-Macros$$ Re: Pl Solve my date query
To: excel-macros@googlegroups.com
Date: Friday, December 7, 2012, 10:55 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 xlst...@gmail.com 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
21 matches
Mail list logo
