Microsoft lists Formula

Question

Hello I am trying to my Asset list to Microsoft Lists and I am trying to what I feel should be an easy thing but I cant get my head round which is create a 2 column which automatically updates by one year to the value of the date in column 1. how is it done.

Jonathan

Answer 1

Dear Jonathan,

Good day!!

As per the description shared, I would like to confirm whether you want to create a column in the List that automatically display the 1-year extended date of another column in the List. If yes, please try the below steps and check the outcome:

Open the List> Settings> List Settings> Scroll down to Columns and click on Create column> Select Calculated Column> Give a name to the column> Enter the following formula manually “=DATE(YEAR([Column 1])+1,MONTH([Column 1]),DAY([Column 1]))”> Make sure to select the Data Type as “Date and Time”> Click OK

Note: Make sure to select the Date Column in the place of Column 1 in the formula.

Output, please check the picture below:

Moreover, if the above formula gave you the Syntax error, please use semi-colon instead of comma: =DATE(YEAR([Column 1])+1;MONTH([Column 1]);DAY([Column 1]))”

If the above formula doesn’t meet your requirement, we apologize and suggest you to share the sample screenshot of the output you can use the Excel workbook to display the output, where it will help us to better understand and guide you further.

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

Best Regards,

Sophia

Answer 2

Seems to be a different Microsoft Lists.

I am using the Web Version. There is no Lists > .. > Settings.

Also, when you create a new column, only 'Number' is available. Then one can select the Curreny value and click on 'calculated formula', which allows to enter a formula.

Unfortunately this functionality does now work correctly.