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 » Dates
Dates
Resolved · Low Priority · Version 2007
Tue 11 Jan 2011, 17:20Delegate Alix said...
Alix has attended:
Excel Advanced course
Dates
Hello,
I would like to be able to add a field that shows the name of the month that a date in the previous column relates to. i.e. in column C it says '12/03/2011' and I would like to put a formula in row D that says 'March' - is such a thing possible?
Thank you.
Wed 12 Jan 2011, 15:13Trainer Anthony said...
RE: Dates
Hi Alix, thanks for your query. This is simpler than you might think. First of all, if C1 says '12/03/2011', then in D1 put "=C1".
Then select C1, r-click Format Cells, choose the Number tab, then Custom and type "mmmm" into the Type: field. That should do the trick!
Hope this helps,
Anthony
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:Working with 3D formulasYou can only use fill-down if you remove $ for Absolute References. |
