# of Days out from Project Finish date

[Jerry Sharpee]

I am trying to find the easiest way to add an additional column (Field) to
show the number of days from Project finish date adjacent to the actual Task
date. I would like tp create a formula refering to the adjacent date with
the finish dae as an absolute, if that would work best.

If anyone can provide the best and easiest solution, I would appreciate it.
--
Jerry Sharpee
CARQUEST Corporation
Professional Markets
Business Development Manager
Raleigh, NC
(e-mail address removed)

 

[JulieS]

Hi Jerry,

Try inserting a number field (for example: Number1) in the table. Then
customize the field (right click in the column heading and choose
Customize Field). Click the formula button and use the following
formula:

ProjDateDiff([Finish],[Project Finish])/[Minutes Per Day]

The formula above will calculate the number of working days from the
finish of the task to the Project Finish date.

The following formula calculates the number of calendar days:

DateDiff("d",[Finish],[Project Finish])

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

 

[Jerry Sharpee]

Thanks for the reply Julie!

I have already got as far as the formula entry, but I am trying to show a
countdown of days based on the date of the task being completed for every
task in the Project so it will show days left next to the date completed.
How do I copy the formula down to every task without reentering it for each
task? I found out this does not work exactly like excel.

Your help appreciated!

Thanks,

Jerry
--
Jerry Sharpee
CARQUEST Corporation
Professional Markets
Business Development Manager
Raleigh, NC
(e-mail address removed)

Hi Jerry,

Try inserting a number field (for example: Number1) in the table. Then
customize the field (right click in the column heading and choose
Customize Field). Click the formula button and use the following
formula:

ProjDateDiff([Finish],[Project Finish])/[Minutes Per Day]

The formula above will calculate the number of working days from the
finish of the task to the Project Finish date.

The following formula calculates the number of calendar days:

DateDiff("d",[Finish],[Project Finish])

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

I am trying to find the easiest way to add an additional column (Field)
to
show the number of days from Project finish date adjacent to the
actual Task
date. I would like tp create a formula refering to the adjacent date
with
the finish dae as an absolute, if that would work best.

If anyone can provide the best and easiest solution, I would
appreciate it.
--
Jerry Sharpee
CARQUEST Corporation
Professional Markets
Business Development Manager
Raleigh, NC
(e-mail address removed)

 

[JulieS]

Hi Jerry,

You're welcome for the help I have provided thus far.

I'm afraid I'm a bit lost about what you are trying to accomplish based
upon your last post. The formula I gave you will calculate the number
of days from the current projected finish of each task as compared to
the finish of the entire project.

Your comment:
"I am trying to show a countdown of days based on the date of the task
being completed for every
task in the Project so it will show days left next to the date
completed. "
has me a bit confused.

Are you looking for the days remaining in each task based upon the
original plan? If so, that data is already in Project in the field
Remaining Duration -- no need for a formula.

The Remaining Duration of a task is the difference between the actual
duration spent, updated by tracking, as compared to the original planned
duration. So for example: a task with an original (planned) duration
of 5 days -- if you have updated the task through tracking to say that
you are 20% complete, you have already worked on the task (actual
duration) of 1 day and you have 4 days remaining duration. The 4 days
of remaining duration is automatically calculated by project.

Let me know if I am close to what you are seeking. If not, I apologize
by try explaining again what you are looking for.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

Thanks for the reply Julie!

I have already got as far as the formula entry, but I am trying to
show a
countdown of days based on the date of the task being completed for
every
task in the Project so it will show days left next to the date
completed.
How do I copy the formula down to every task without reentering it for
each
task? I found out this does not work exactly like excel.

Your help appreciated!

Thanks,

Jerry
--
Jerry Sharpee
CARQUEST Corporation
Professional Markets
Business Development Manager
Raleigh, NC
(e-mail address removed)

Hi Jerry,

Try inserting a number field (for example: Number1) in the table.
Then
customize the field (right click in the column heading and choose
Customize Field). Click the formula button and use the following
formula:

ProjDateDiff([Finish],[Project Finish])/[Minutes Per Day]

The formula above will calculate the number of working days from the
finish of the task to the Project Finish date.

The following formula calculates the number of calendar days:

DateDiff("d",[Finish],[Project Finish])

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information
about Microsoft Project

I am trying to find the easiest way to add an additional column
(Field)
to
show the number of days from Project finish date adjacent to the
actual Task
date. I would like tp create a formula refering to the adjacent
date
with
the finish dae as an absolute, if that would work best.

If anyone can provide the best and easiest solution, I would
appreciate it.
--
Jerry Sharpee
CARQUEST Corporation
Professional Markets
Business Development Manager
Raleigh, NC
(e-mail address removed)

 

[Mike Glen]

Hi Jerry,

If you have inserted the number column, right-click on the column heading
and select Customize Fields... Then click the Formula... button in the
center, then paste in the formula that Julie gave you and OK out. That's
what Julie ment by customize the field.

You might like to have a look at my series on Microsoft Project in the
TechTrax ezine, particularly #14 & 15 on customizing fields, at this site:
http://tinyurl.com/2xbhc or this:
http://pubs.logicalexpressions.com/Pub0009/LPMFrame.asp?CMD=ArticleSearch&AUTH=23
(Perhaps you'd care to rate the articles before leaving the site,
Thanks.)

FAQs, companion products and other useful Project information can be seen at
this web address: <http://www.mvps.org/project/>

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP

Thanks for the reply Julie!

I have already got as far as the formula entry, but I am trying to
show a countdown of days based on the date of the task being
completed for every task in the Project so it will show days left
next to the date completed. How do I copy the formula down to every
task without reentering it for each task? I found out this does not
work exactly like excel.

Your help appreciated!

Thanks,

Jerry

Hi Jerry,

Try inserting a number field (for example: Number1) in the table.
Then customize the field (right click in the column heading and
choose Customize Field). Click the formula button and use the
following formula:

ProjDateDiff([Finish],[Project Finish])/[Minutes Per Day]

The formula above will calculate the number of working days from the
finish of the task to the Project Finish date.

The following formula calculates the number of calendar days:

DateDiff("d",[Finish],[Project Finish])

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

I am trying to find the easiest way to add an additional column
(Field) to
show the number of days from Project finish date adjacent to the
actual Task
date. I would like tp create a formula refering to the adjacent
date with
the finish dae as an absolute, if that would work best.

If anyone can provide the best and easiest solution, I would
appreciate it.
--
Jerry Sharpee
CARQUEST Corporation
Professional Markets
Business Development Manager
Raleigh, NC
(e-mail address removed)

 

[Jerry Sharpee]

Thanks Julie and Mike,

That did the trick! I was in the Excel thinking mode and thought that I
needed to copy the formula in each cell for each task in the column field to
make it work. I now understand that by copying it to the custom field it is
entered as part of every cell in that field column. You both have been
extremely helpful!

Thanks again,
--
Jerry Sharpee
CARQUEST Corporation
Professional Markets
Business Development Manager
Raleigh, NC
(e-mail address removed)

Hi Jerry,

If you have inserted the number column, right-click on the column heading
and select Customize Fields... Then click the Formula... button in the
center, then paste in the formula that Julie gave you and OK out. That's
what Julie ment by customize the field.

You might like to have a look at my series on Microsoft Project in the
TechTrax ezine, particularly #14 & 15 on customizing fields, at this site:
http://tinyurl.com/2xbhc or this:
http://pubs.logicalexpressions.com/Pub0009/LPMFrame.asp?CMD=ArticleSearch&AUTH=23
(Perhaps you'd care to rate the articles before leaving the site,
Thanks.)

FAQs, companion products and other useful Project information can be seen at
this web address: <http://www.mvps.org/project/>

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP

Thanks for the reply Julie!

I have already got as far as the formula entry, but I am trying to
show a countdown of days based on the date of the task being
completed for every task in the Project so it will show days left
next to the date completed. How do I copy the formula down to every
task without reentering it for each task? I found out this does not
work exactly like excel.

Your help appreciated!

Thanks,

Jerry

Hi Jerry,

Try inserting a number field (for example: Number1) in the table.
Then customize the field (right click in the column heading and
choose Customize Field). Click the formula button and use the
following formula:

ProjDateDiff([Finish],[Project Finish])/[Minutes Per Day]

The formula above will calculate the number of working days from the
finish of the task to the Project Finish date.

The following formula calculates the number of calendar days:

DateDiff("d",[Finish],[Project Finish])

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project


message I am trying to find the easiest way to add an additional column
(Field) to
show the number of days from Project finish date adjacent to the
actual Task
date. I would like tp create a formula refering to the adjacent
date with
the finish dae as an absolute, if that would work best.

If anyone can provide the best and easiest solution, I would
appreciate it.
--
Jerry Sharpee
CARQUEST Corporation
Professional Markets
Business Development Manager
Raleigh, NC
(e-mail address removed)

 

[Mike Glen]

You're welcome, Jerry, and keep reading the articles

Mike Glen
MS Project MVP

Thanks Julie and Mike,

That did the trick! I was in the Excel thinking mode and thought
that I needed to copy the formula in each cell for each task in the
column field to make it work. I now understand that by copying it to
the custom field it is entered as part of every cell in that field
column. You both have been extremely helpful!

Thanks again,

Hi Jerry,

If you have inserted the number column, right-click on the column
heading and select Customize Fields... Then click the Formula...
button in the center, then paste in the formula that Julie gave you
and OK out. That's what Julie ment by customize the field.

You might like to have a look at my series on Microsoft Project in
the TechTrax ezine, particularly #14 & 15 on customizing fields, at
this site: http://tinyurl.com/2xbhc or this:
http://pubs.logicalexpressions.com/Pub0009/LPMFrame.asp?CMD=ArticleSearch&AUTH=23
(Perhaps you'd care to rate the articles before leaving the site,
Thanks.)

FAQs, companion products and other useful Project information can be
seen at this web address: <http://www.mvps.org/project/>

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP

Thanks for the reply Julie!

I have already got as far as the formula entry, but I am trying to
show a countdown of days based on the date of the task being
completed for every task in the Project so it will show days left
next to the date completed. How do I copy the formula down to every
task without reentering it for each task? I found out this does not
work exactly like excel.

Your help appreciated!

Thanks,

Jerry

Hi Jerry,

Try inserting a number field (for example: Number1) in the table.
Then customize the field (right click in the column heading and
choose Customize Field). Click the formula button and use the
following formula:

ProjDateDiff([Finish],[Project Finish])/[Minutes Per Day]

The formula above will calculate the number of working days from
the finish of the task to the Project Finish date.

The following formula calculates the number of calendar days:

DateDiff("d",[Finish],[Project Finish])

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project


message I am trying to find the easiest way to add an additional column
(Field) to
show the number of days from Project finish date adjacent to the
actual Task
date. I would like tp create a formula refering to the adjacent
date with
the finish dae as an absolute, if that would work best.

If anyone can provide the best and easiest solution, I would
appreciate it.
--
Jerry Sharpee
CARQUEST Corporation
Professional Markets
Business Development Manager
Raleigh, NC
(e-mail address removed)

 

[JulieS]

Hi Jerry,

Glad you were able to get it sorted out. Thanks very much for the
feedback and do let us know if you have any further questions.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

Thanks Julie and Mike,

That did the trick! I was in the Excel thinking mode and thought that
I
needed to copy the formula in each cell for each task in the column
field to
make it work. I now understand that by copying it to the custom field
it is
entered as part of every cell in that field column. You both have
been
extremely helpful!

Thanks again,
--
Jerry Sharpee
CARQUEST Corporation
Professional Markets
Business Development Manager
Raleigh, NC
(e-mail address removed)

Hi Jerry,

If you have inserted the number column, right-click on the column
heading
and select Customize Fields... Then click the Formula... button in
the
center, then paste in the formula that Julie gave you and OK out.
That's
what Julie ment by customize the field.

You might like to have a look at my series on Microsoft Project in
the
TechTrax ezine, particularly #14 & 15 on customizing fields, at this
site:
http://tinyurl.com/2xbhc or this:
http://pubs.logicalexpressions.com/Pub0009/LPMFrame.asp?CMD=ArticleSearch&AUTH=23
(Perhaps you'd care to rate the articles before leaving the site,
Thanks.)

FAQs, companion products and other useful Project information can be
seen at
this web address: <http://www.mvps.org/project/>

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP

Thanks for the reply Julie!

I have already got as far as the formula entry, but I am trying to
show a countdown of days based on the date of the task being
completed for every task in the Project so it will show days left
next to the date completed. How do I copy the formula down to every
task without reentering it for each task? I found out this does
not
work exactly like excel.

Your help appreciated!

Thanks,

Jerry

Hi Jerry,

Try inserting a number field (for example: Number1) in the table.
Then customize the field (right click in the column heading and
choose Customize Field). Click the formula button and use the
following formula:

ProjDateDiff([Finish],[Project Finish])/[Minutes Per Day]

The formula above will calculate the number of working days from
the
finish of the task to the Project Finish date.

The following formula calculates the number of calendar days:

DateDiff("d",[Finish],[Project Finish])

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project


message I am trying to find the easiest way to add an additional column
(Field) to
show the number of days from Project finish date adjacent to the
actual Task
date. I would like tp create a formula refering to the adjacent
date with
the finish dae as an absolute, if that would work best.

If anyone can provide the best and easiest solution, I would
appreciate it.
--
Jerry Sharpee
CARQUEST Corporation
Professional Markets
Business Development Manager
Raleigh, NC
(e-mail address removed)