In cell C3 to C78 I am writting date as "DD-MM-YYYY". I am writting 30-Apr-2009. I want a result at G3 just one year after the date I entered at cell C3. So, my result at G3 would be 30 Apr-2010. How can I get it? Please help me.
=date(year(c3)+1,month(c3),day(c3))
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
If C3 is recognized by Excel as an actual date value, then put this in G3:
=DATE(YEAR(C3)+1,MONTH(C3),DAY(C3))
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Try this:
=C3+DATE(1,1,-1)
"Relax. What is mind? No matter. What is matter? Never mind!"
Hi Chandan, welcome to the forum. In the future, please use a thread title more descriptive of your problem, like "how to add dates".
For this problem, try using:
=DATE(YEAR(C3)+1,MONTH(C3),DAY(C3))
Thanks!
That formula has a leap year problem, zbor.=C3+DATE(1,1,-1)
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
You are right. When I test it I checked for 29.2.2008 but I didn't check it for 28.2.2008Originally Posted by shg
"Relax. What is mind? No matter. What is matter? Never mind!"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks