DATEONLY Formula Error Message

Bob Lach

I cannot get my DATEONLY formula to work.  It keeps giving me "missing or invalid parameters" as the result.  I am trying to create a formula that gives me a date variance between Planned Start and Actual Start.  My two column names are Planned Start and Start and I am trying to start in row 5.  This is the formula I have and it results in Missing or Invalid Parameters.  

 

=DATEONLY([Planned Start]5 - Start5)

 

I also checked to make sure both columns are set to date as the column properties, etc.  

 

Thanks for the help.

Bob

J. Craig Williams

Depending on which one is the start date associated in the Project Settings (the one you see on the Gantt chart)

 

either this

 

=DATEONLY([Planned Start]5) - Start5

 

or this

 

=[Planned Start]5 - DATEONLY(Start5)

 

is your problem.

Use DATEONLY for the column with the Date/Time type column. The other should be a Date type column.

A Date type column will be changed to Date/Time when it is associated with the Project Settings functionality.

 

Hope this helps.

Craig

 

 

 

Bob Lach

That worked.  Thanks so much for the help!!!  Saved my day. 

 

Bob

J. Craig Williams

Glad to help

 

Craig