Project duration and date

TaliRXM

Hello,

I have created a 'simple' of Project sheet (w Gantt) where I track different activities (no sub-tasks).

• - how do I change the 'Duration' from showing in days to show in weeks (or months)?
• - how do I set up the 'Finish' date to automatically reflect current day, so that every day I open the sheet it will reflect the duration up to date?

Thanks!

Tali

Capture.PNG

Genevieve P.

Hi @TaliRXM

If you don't need to use Dependencies, I would actually un-check this from your Project Settings:

This way you can then write formulas into your two columns!

For the Finish date, you can use the following formula:

=TODAY()

This will automatically update the cell with today's date when you open the sheet. See: TODAY Function

Then for your Duration column, do you want Weeks or Months? I presume you want to include weekend dates in this calculation, right?

You can use a simple Finish@row - Start@row to find the number of days between the dates. Then if you want Weeks, we could divide this number by 7. See: Use Formulas to Perform Calculations With Dates

Ex:

=(Finish@row - Start@row) / 7

Let me know if this helps you present the data you need!

Cheers,

Genevieve

TaliRXM

@Genevieve P. Thank you!

I am using the Duration' so un-check Dependencies will eliminate that.

I will follow your suggestions

TaliRXM

Hi again Genevieve,

What if I don't want to include weekend dates in the formula (i.e. calculating only (5) working days)?

How the formula will look like?

Thanks and have a great weekend!

Tali

Genevieve P.

Hi @TaliRXM

There's a NETWORKDAYS Function that can identify the number of workdays between tasks, like so:

=NETWORKDAYS(Start@row, Finish@row)

Then if you want the Week, you would need to divide by 5 instead of 7, like so:

=NETWORKDAYS(Start@row, Finish@row) / 5

Cheers,

Genevieve

TaliRXM

Thanks Genevieve

Tali