Hello Zoher,
It's very short and easy to remember. Only cell address + number of months
are required. Thank you.
Regards
Mukesh Baviskar
--------------------------------------------------
From: "zoher" <[email protected]>
Sent: Sunday, June 17, 2012 11:21 AM
To: <[email protected]>
Subject: Re: [AI] Excel formula
you can use edate function also.
if your date is in a1 then type the following formula.
=edate(a1,60)
note the cell where you type the formula, after getting the answer convert
it in to date format by pressing ctrl 1, number tab, date.
zoher kheriwala taheri menswear mumbai. skype id zoher.kheriwala
----- Original Message -----
From: "Mukesh" <[email protected]>
To: <[email protected]>
Sent: Sunday, June 17, 2012 9:59 AM
Subject: Re: [AI] Excel formula
It's working fine. Thank you for your quick guidance.
Regards
Mukesh Baviskar
--------------------------------------------------
From: "Chetan Sharma" <[email protected]>
Sent: Sunday, June 17, 2012 9:29 AM
To: <[email protected]>
Subject: Re: [AI] Excel formula
Assuming that you have a date in cell A1. The following formula is one
simple way to come up with a date five years later.
=DATE(YEAR(A1)+5,MONTH(A1),DAY(A1))
HTH!
On 6/17/12, Mukesh <[email protected]> wrote:
Dear friends,
I'm in a need of a following excel formula urgently to complete my
database.
I want to know the date after 5 year. for example:
First date: 28/5/2007 and date after 5 years: 28/5/2012.
Please tell me the formula to get this answer automatically by formula.
Waiting for your positive response at the earliest. Thank you.
Sincerely,
Mukesh Baviskar
Mobile: 9403161157
Search for old postings at:
http://www.mail-archive.com/[email protected]/
To unsubscribe send a message to
[email protected]
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please
visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
--
The greatest pleasure in life is doing what people say you cannot do.
Search for old postings at:
http://www.mail-archive.com/[email protected]/
To unsubscribe send a message to
[email protected]
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/[email protected]/
To unsubscribe send a message to
[email protected]
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/[email protected]/
To unsubscribe send a message to
[email protected]
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/[email protected]/
To unsubscribe send a message to
[email protected]
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes, please
visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
