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 » How to enter months depending on dates?
How to enter months depending on dates?
Resolved · Low Priority · Version 2003
Fri 6 Nov 2009, 13:56Delegate Joanna said...
Joanna has attended:
Visio Introduction course
Visio Advanced course
Excel Advanced course
How to enter months depending on dates?
when we can only input 9 ifs in a function?
Tue 10 Nov 2009, 07:57Trainer Anthony said...
RE: how to enter months depending on dates?
Hi Joanna, there is a limit on the number of IF functions you can nest and there are various rather complicated ways round it. However, why not use data formatting to achiever what you want?
If column A has the dates, then make the formula in B1 "=A1" then autofill down. Then Format Column B to display the date just as a Month.
Hope this helps,
Anthony
Mon 16 Nov 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:Formst Excel to display leading zeroesSelect the cells that you want to have displaying leading zeroes. |
