LinkBack URL
About LinkBacks
Hi,
I have a formula
=DATE(YEAR(A1),MONTH(A1)+1,DAY(14))
A1 = 24/11/12
Result = 14/12/12
Correct!
if A1 = 13/12/12
I need the result to return 14/12/12, not 14/01/13
Incorrect!
Please Help!
Hi,
I have a formula
=DATE(YEAR(A1),MONTH(A1)+1,DAY(14))
A1 = 24/11/12
Result = 14/12/12
Correct!
if A1 = 13/12/12
I need the result to return 14/12/12, not 14/01/13
Incorrect!
Please Help!
Duplicate post
http://www.excelforum.com/excel-new-...html?p=3020718
Last edited by FDibbins; 11-24-2012 at 08:09 PM.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks