Spreadsheet Formula Issues: Date

 
1
0
-1

Hi Team,

I need help in the spreadsheet.  Below the format. I want to enter no. of days . Based on Start date,  End Date value automatically set in the column.

e.g. Today is a 20-Oct-2021 and no. of days is equal to 1 than end date same. 

If no. of days is equal 2  than end date start date +2 days is equal to end date 

Weekend is not consider.

No. of daysStart DateEnd Date
120-Oct-2120-Oct-21
220-Oct-2121-Oct-21
420-Oct-2123-Oct-21

We have checked spreadsheet formula to show the default date in the column is not working. 

Suggest me how to work the formula also in the column.

DATE(year, month, day)
DATEVALUE(date_text)
DAY(serial_number)
DAYS(end_date, start_date)
DATE(year, month, day)

Appreciate if help regarding this issues.


    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Hi, I am not that familiar but would think that you need some kind of custom JavaScript to do it using Spreadsheet Deep Customizations and https://handsontable.com/docs/6.2.2/demo-summary-calculations.html. Can you share your solution if you managed to solve it? 

        CommentAdd your comment...