Autofile date based on the date in another cell

Copper Contributor

I have a spreadsheet with several columns and those columns include dates an order is ordered, estimated to ship, estimated delivery, and actual delivery date.  I get the estimated delivery date from a confirmation that we input but I need to fill in the estimated to ship column with a date that is 45 days prior to the estimated delivery date.  Is there a function I can input into the cell in the estimated to ship column that will automatically input that date based on the date in the estimated delivery column?

2 Replies

@Leach826 As long as the estimated delivery date is a real date value, let's say in A1, you can enter a formula like:


in another cell where you want the ship date to show up.

That's so simple. I was trying to over think that. Thanks for your help that gave me what I needed.