Date Calculations

Mary Pat Aust

Hi there,

I am trying to do a simple formula for a date to automatically populate in the Date Due column. I take the Event date and subtract the number of days prior to the meeting for each individual due date. This is the formula I created.

However, when I run this formula in the Date Due column, nothing is returned.

What am I doing wrong?

Thank you,😕

David Dolch

If you are looking for a date, then do not use the SUM function

=[Board Event Date]@row-[#Days PTM]@row.

David Dolch

If you are looking for a date, then do not use the SUM function

=[Board Event Date]@row-[#Days PTM]@row.

Mary Pat Aust

Thank you so much. I know formulas can be my friend but they are going to kill me. 😎

David Dolch

You are welcome

They are close, but just different enough from other formula syntax (Excel, SQL, etc) to make me have to go and check syntax every so often myself.