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
 
Top