EDate() function is good for adding months/years to a given date, it would not support addition of days to a given date. For example, it would not yield correct result if I wish to determine the days 45 days after today. The Date() function suggested by Chetan comes in handy in such situations:
=DATE(YEAR(A1),MONTH(A1),DAY(A1)+45) Also, the Date() function returns a date value, so you don't need a format conversion. On 6/17/12, zoher <zos...@gmail.com> wrote: > 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" <mukeshbaviskar....@gmail.com> > To: <accessindia@accessindia.org.in> > 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" <danzig2...@gmail.com> >> Sent: Sunday, June 17, 2012 9:29 AM >> To: <accessindia@accessindia.org.in> >> 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 <mukeshbaviskar....@gmail.com> 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/accessindia@accessindia.org.in/ >>>> >>>> To unsubscribe send a message to >>>> accessindia-requ...@accessindia.org.in >>>> 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/accessindia@accessindia.org.in/ >>> >>> To unsubscribe send a message to >>> accessindia-requ...@accessindia.org.in >>> 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/accessindia@accessindia.org.in/ >> >> To unsubscribe send a message to >> accessindia-requ...@accessindia.org.in >> 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/accessindia@accessindia.org.in/ > > To unsubscribe send a message to > accessindia-requ...@accessindia.org.in > 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 > > -- Best Regards, Zujar... An optimist laughs to forget, whereas a pessimist forgets to laugh! Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in 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