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.
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
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
