Using Modified Date in a formula returns #date Expected

Mark Morris

Hello, I am trying to determine whether or not a row should be added to a weekly report by trying use the modified system column to calculate the associated Friday.

e.g. It's Tuesday and I make a change, I want my other column 'Report week end date' to display that upcoming Friday.

=IF(WEEKDAY(Modified@row) < 6, DATE(YEAR(Modified@row), MONTH(Modified@row), DAY(Modified@row) + (7 - WEEKDAY(Modified@row)), "Error"))

Just to see, I put "=WEEKDAY(Modified@row)" into the cell and got #DATE EXPECTED.

Can you not use Modified as a DATE type?

Thanks,

Mark

Paul Newcome

On its own you cannot. You would need to incorporate the DATEONLY function.

=YEAR(DATEONLY(Modified@row))