Please help me on a formula

[hanni]

Hi,

what I am trying to do is to add aformula that will caculate finish
date vs. current date and will alert me somehow if finish date is 2
weeks from now.

1. Can i, by a formula, ask to calculate this only for if the task
name begin with the word "receive"?
2. I added the formula: IIf([Finish]=[Current Date]+16,"1","0") and
received "0". I tried to change the number to [current date] + 12 or
13 etc. and still got only "0". When I changed the "+" to ">" I
received some "1"s (1 means that finish date in in 2 weeks = 10 days
or 12?) but I would like to have this alert only if it is exactly 2
weeks....

Can you help me?

Thanks,
Hanni

 

[Jan De Messemaeker]

Hi,

Q1: Yes. you can write an Iif with the Instr fuction (the nalme contains a
string)
Q2. Don't add numerics to dates; use the ProjDateAdd function.

Hope this helps,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[JulieS]

Hello Hanni,

In quick testing the formula below does what I think you are looking
for:
For tasks containing the word "receive" and that have a finish date
exactly equal to today's date plus 16 days, show 1 if not, show 0.

IIf(InStr([Name],"receive")>0 And ProjDateDiff([Current
Date],[Finish],"standard")=16*[Minutes Per Day],1,0)

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