Calculate the date of the next Friday dependent on the current dat

[Chris Marriott]

I am trying to write a formula that compares a tasks start date with the date
of the next Friday depending on the current date. This will negate the need
for Project Managers to update the status date in the project plans for my
reports to be accurate.

Can anyone help with a function that will calculate the date of the next
Friday based on the current date.

Any help much appreciated.

 

[Ray McCoppin]

Below are formula that will retrun the friday of the curent week assumming
the week starts on Sunday. One that uses the project curent date the other
uses the curent time now.

DateAdd("d",5 - Weekday([Current Date],1),[Current Date])

DateAdd("d",5 - Weekday(Now(),1),Now)

Hope this helps
--
Ray McCoppin

http://www.randsmanagement.com
Project Server 2007 archive tool
SRS gantt charts

 

[Chris Marriott]

Ray

Thank you for your help. You have saved me from a couple of migraines.

Much appreciated.

--
Regards


Chris Marriott

Below are formula that will retrun the friday of the curent week assumming
the week starts on Sunday. One that uses the project curent date the other
uses the curent time now.

DateAdd("d",5 - Weekday([Current Date],1),[Current Date])

DateAdd("d",5 - Weekday(Now(),1),Now)

Hope this helps
--
Ray McCoppin

http://www.randsmanagement.com
Project Server 2007 archive tool
SRS gantt charts

I am trying to write a formula that compares a tasks start date with the date
of the next Friday depending on the current date. This will negate the need
for Project Managers to update the status date in the project plans for my
reports to be accurate.

Can anyone help with a function that will calculate the date of the next
Friday based on the current date.

Any help much appreciated.
--
Regards


Chris Marriott