# Calculating 14 day due date

Hello,

I'm attempting to collect training metrics by department and I'm unsure how to incorporate a formula to identify criteria for training due 14 days from today. The below formula references a report with a Due Date column, not sure sure how to create the criteria for due dates 14 days from today.

Tags:

• ✭✭✭✭✭✭

If you have due date column and you can create another column which will check the due date from today. Create another column and try the below formula, if the value is 1 then the due date is in next 14 or less than 14 days.

=IF(Date@row - TODAY() <= 14, 1, 0)

Regards

Amit WadhwaniSmartsheet CoE, Ignatiuz Software, Exton, PA

Best Regards

Smartsheet CoE, Ignatiuz Software, Exton, PA

• ✭✭✭✭✭✭

If you have due date column and you can create another column which will check the due date from today. Create another column and try the below formula, if the value is 1 then the due date is in next 14 or less than 14 days.

=IF(Date@row - TODAY() <= 14, 1, 0)

Regards

Amit WadhwaniSmartsheet CoE, Ignatiuz Software, Exton, PA

Best Regards

Smartsheet CoE, Ignatiuz Software, Exton, PA