Forum home » Delegate support and help forum » Microsoft Excel Training and help » How to enter months depending on dates?
|
|
|
The UK's most regular 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. |
How to enter months depending on dates?
Resolved · Low Priority · Version 2003
Reply 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?
For upcoming training course dates see: Pricing & availability
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.
|