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 Formating
Date Formating
Resolved · Low Priority · Version 2003
Tue 16 Sep 2008, 16:45Delegate Jyoti said...
Jyoti has attended:
Excel Intermediate course
Excel Advanced course
Excel VBA Intro Intermediate course
Date Formating
A function key to be able to calculate only weekdays (and minus weekend dates).
How to make a vertical list and associating information into a horizantal row with info going downwards.
Tue 16 Sep 2008, 17:02Trainer David said...
RE: Date Formating
Hi Jyoti
I can help you with the second part of your question and refer the first part on to one of my collegues.
Copy the information you wish to move horizontally and then choose paste special and check transpose.
Hope that helps
Wed 17 Sep 2008, 16:04Trainer David said...
RE: Date Formating
Hi Jyoti
Thank you for your question.
If you look up NETWORKDAYS in Excel help, this will explain how this function works....basically it will give you the number of working days between two dates (excludes weekends and public holidays in it's count of days).
Amanda
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:Shortcuts for working with named ranges in ExcelIf you are working with or creating named ranges in your spreadsheets, then you may find the following shortcut keys useful. |
