Forum Discussion
Kneshalewiseeocgov
Jan 10, 2023Copper Contributor
excel dates
Hi, I hope someone can help. I am working on spreadsheet with a column that will have received dates for cases as they come in and I want to add a column that will add 30 days to that date automatica...
HansVogelaar
Jan 10, 2023MVP
Let's say you have dates in D2 and down. In another column, enter this formula in row 2, then fill down:
=IF(D2="","",D2+30)
If your data are in a table, you can use a formula such as
=IF([@[Date Received]]="","",[@[Date Received]]+30)
where Date Received is the name of the date column.
This will propagate to new rows automatically.
- KneshalewiseeocgovJan 10, 2023Copper ContributorThank you but I do not have dates listed yet and each date will be different depending on receipt.