Forum Discussion
Solved
Problems with date calculation
I have a column for "Date Submitted" and a calculated column for "Due Date". the Due Date column is calculated for -45 days from a third column "Implementation Date". My calculated column is workin...
ON TIME = IF(DATEVALUE([Date Submitted]) <= [Due Date], "On Time", "Late")
ON TIME = IF(DATEVALUE([Date Submitted]) <= [Due Date], "On Time", "Late")