Spreadsheet Formula Issues: Date
Confluence User - 20 Oct, 2021
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 days | Start Date | End Date |
| 1 | 20-Oct-21 | 20-Oct-21 |
| 2 | 20-Oct-21 | 21-Oct-21 |
| 4 | 20-Oct-21 | 23-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.
forms;spreadsheet