98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Date forumulas
Date forumulas
Resolved · High Priority · Version 2003
Mon 2 Mar 2009, 08:34Delegate Su said...
Su has attended:
Excel Introduction course
Date forumulas
I have a spreadsheet with a date in the first column the 2nd column date needs to be one year on from this and the 3rd column date 2 years on. Anyone know how to set this up?
Tue 3 Mar 2009, 10:23Trainer Cress said...
RE: Date forumulas
Hello Su
Thank you for your question
Assuming the original date is in cell A1, try this formula in another cell and remember to format the column as date:
=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))
If this resolves your question, please mark it as resolved. If not, please reply with more information.
Kind regards
Cress
Tue 10 Mar 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:LARGE and SMALL functions and their usesTwo of Excel's most common functions are the MAX and MIN functions which will display the largest (MAX) or smallest (MIN) value in a series. What if you need the 2nd or 3rd largest or smallest values instead of the largest or smallest? |
