Share via

I am using Microsoft list and have added a calculated column but I need to modify my formula and I'm struggling with the syntax of the modifed formula

Anonymous
2023-04-13T13:29:36+00:00

My current formula reads =IF(ISBLANK([COLUMN 1]),"",TODAY()-[COLUMN 1]). I need to add in this formula to only run the calculated column if column 2 is blank or at a later date. If the date of column 2 is a previous date I don't need the value in the calculated column. Column represents a start date and column 2 is the end date. I need Column 3 (the calculated column) to show the number of days from start (column 1) to today unless their is an end date (column 2). Please help!

Microsoft 365 and Office | SharePoint | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-04-14T13:06:49+00:00

    Dear User,

    Good day!!

    As per your requirement, please check whether you are looking for the output as below:

    If yes, here is the formula you can use:

    =IF(OR(ISBLANK([COLUMN 2]),[COLUMN 2]>TODAY()),IF(ISBLANK([COLUMN 1]),"",(TODAY()-[COLUMN 1])),"")

    If not, you can share your required output in the form screenshot which will help us to better understand and guide you with correct formula.

    Appreciate your patience and understanding. Have a good day!!

    Best Regards,

    Sophia

    0 comments