Use modified calendar in excel calculations

B

briancarroll101

I wish to plan dates when certain actions in a project are due for
completion. Project is not suitable for my needs as i am creating a
spreadsheet with several types of information. The problem is that i wish to
either modify the calendar used in excel so as to exclude weekend days, bank
holidays and several days over the christmas period and do not know how to do
this. Alternativly I could create a new data type much like the one uesd for
caluclating dates in excel where a value is attributed to each date and
unnecessary days could just be skipped and not given a value.

Anyone know how i could implement either of these approaches?

Thanks
 

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

Top