Forum Discussion
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...
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.
- Thank you but I do not have dates listed yet and each date will be different depending on receipt.
