calender days in excel

K

K-Man

Hi,

I am trying to create calender days in excel to calculate numbers of
hours spent on a particular activity starting from Mon - Sun. I can
do this for current year however will have to redo the spreadsheet for
next year and so on..any way I can automate this?

Thanks for the help,
al
 
S

Sheeloo

Use the networkdays formula
It gives you the working days between two dates and you can also account for
holidays... Lookup Excel Help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Floating calender 1
Calender in E2007 2
Active X CAlender day colour 2
Excel to add event on outlook calender 1
Calender not working in excel 2007?? 2
How to write XIRR formula on excel using different Year basis than 365. 5
Calenders in Excel? 1
Integration between VB and Excel 1

Top