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

"K-Man" wrote:

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