calender days in excel

  • Thread starter Thread starter K-Man
  • Start date Start date
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
 
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

Calender in E2007 2
Active X CAlender day colour 2
Calender not working in excel 2007?? 2
Insert Date in correct cell 4
Calenders in Excel? 1
How to write XIRR formula on excel using different Year basis than 365. 5
sum matrix cells based on value in a separate cell 1
How do I do a drop down box with calender in excel? 4

Back
Top