Forum Discussion
On Boarding
"I'm trying to track all the responsibilities that the various functions need to perform.
Column A Task to be performed Column B Start date Column C Closing date Column D Responsible function Column E Activity status
In the activity status, I'd like to use the "IF" function in relation to the closing date to enter completed or not completed.
I'm trying to do this but I'm having trouble.
Thank you for the support!"
1 Reply
To use the IF function in relation to the closing date to determine whether a task is completed or not, you can follow these steps:
Assuming that your data is in columns A to E (A for the task, B for the start date, C for the closing date, D for the responsible function, and E for the activity status), you can use the IF function in column E.
In cell E2 (assuming your data starts in row 2), you can use the following formula:
=IF(C2<>"", IF(C2<=TODAY(), "Completed", "Not Completed"), "")
Here's an explanation of the formula:
- IF(C2<>"", ...) checks if the closing date (cell C2) is not blank. If it's blank, the formula will return an empty string (""). If it's not blank, it proceeds to the next IF.
- IF(C2<=TODAY(), "Completed", "Not Completed") checks if the closing date (cell C2) is less than or equal to today's date (TODAY()). If it is, the formula returns "Completed"; otherwise, it returns "Not Completed."
This formula will mark a task as "Completed" if the closing date has passed or as "Not Completed" if the closing date is in the future. If there's no closing date specified, it will leave the cell empty.
Drag the fill handle of cell E2 down to apply this formula to the entire column for all your tasks. The activity status will update based on the closing date and the current date. The text was created with the help of AI.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
