Using Modified Date in a formula returns #date Expected
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?
Help Article Resources
Check out the Formula Handbook template!