Project Calendars

Hi Hai-anh

Thank you for your question.

One option that may work is to get Excel to calculate the deadline date from the due date. For example you might have a column that showed the due date for a task and next door add a formula that deducted 10 from it to produce a date ten days earlier.

This will give you 10 calendar days prior to delivery so you may prefer to only count project days (excluding weekends). Excel can help with this using the Workday() function. The syntax is

Workday(start_date,number of days offset, holiday dates)

=WORKDAY(C1,-10) where C1 contains the Due date
The result will the 10 working days earlier. You may need to format the cell in date format. The start_date has to be a serial number date (e.g. referring to a cell already containing a date or entered using the DATE() function e.g. DATE(2008,5,23) for the 23rd day of May, 2008). You can use positive numbers to calculate a working date in the future.

I hope this helps. Let me know a little more about how you would like to show your Project deadlines and I will see if there are some other ideas that may help.

Kind regards,
Andrew