Hi All
My query is with regards to the date function. In excel 2003(at my office) when i am using the date function
to add 6 months it is returning correct value for few dates. But for a date like 01/10/2011
where it should show 01/04/2012 but it is showing a date with the years 2011 ( 11/07/2011). Is there some
constraint with in excel 2003 with regards date function that needs to be followed so that it can
automatically to display the next year if the resultant date is in the next year when 6months is added.
I have just checked this on 2007(At my residence) the result is correct. so whats wrong with 2003. do i need to change the default format in the cell box
Please note the user inputs the date through a input box that i have created . date values goes into b1. b2 then should add 6 months to b1 to display the result.
Help please
Hi
If your date is in A2, then use this formula to take your result.
=DATE(YEAR(A2);MONTH(A2)+6;DAY(A2))
If it's necessary, chance the semicolon to gomma.
Hope to helps you
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
I assume the date is October 1st? Did you enter the function like:
=DATE(YEAR(K2),MONTH(K2)+6,DAY(K2))
where K2 contains the original date.
also could use
=EDATE(K2,6)
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Hi
I applied =DATE(YEAR(A1),MONTH(A1)+6,DAY(A1)) to 01/10/2011 and got the correct answer (inXL2003)
Maybe post a small sample so we can see what is wrong
Cheers - THE WARNING I RECEIVED WAS NOT JUSTIFIED
Thanx to all my freinds moderator, contributor, user , u r stars. u guys helped me a lot
i will try this in my office on excel 2003 and check if it is calculating to 6 months if the number of months are crossing the current year.
After u r replies i am sure it will work. good day guys
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks