Date Delta

[Penny]

I have a custom date field (Fin 1). I would like to have a formula that will
give me the number of days from that Fin 1 date until today. Is that
possible?

Thanks.

Penny

 

[John]

I have a custom date field (Fin 1). I would like to have a formula that will
give me the number of days from that Fin 1 date until today. Is that
possible?

Thanks.

Penny

Penny,
Yes, try the following formula in a spare duration field (e.g. Duration1)

Duration1=Projdatediff(Now(),[Finish1])

The above formula makes some assumptions
1. You want the difference in working time, not calendar time.
2. You want the result in days, not hours, weeks, or something else.

Hope this helps.

John
Project MVP

 

[Penny]

John thank you for providing this formula. However, the formula is not
returning any value. I am getting an error in some fields but this is
because in some of the Finish 1 fields there is not a date yet. But I am
uncertain why it is not returning me a value.

Thanks.

I have a custom date field (Fin 1). I would like to have a formula that will
give me the number of days from that Fin 1 date until today. Is that
possible?

Thanks.

Penny

Penny,
Yes, try the following formula in a spare duration field (e.g. Duration1)

Duration1=Projdatediff(Now(),[Finish1])

The above formula makes some assumptions
1. You want the difference in working time, not calendar time.
2. You want the result in days, not hours, weeks, or something else.

Hope this helps.

John
Project MVP