By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table mytable (
startdate datetime not null,
noofdays int not null,
enddate as dateadd(day, noofdays, startdate)
)
insert into mytable (startdate, noofdays) values(getdate(), 3);
1 rows affected
select * from mytable;
startdate | noofdays | enddate |
---|---|---|
2020-12-12 01:40:16.903 | 3 | 2020-12-15 01:40:16.903 |