Auto fill date
Is it possible to set a date cell to auto-fill based on a date from another cell?
I'm setting up a task list which tracks the ordering of materials required to sites. I have a column 'date required on site'. I am adding another column 'order to be placed by'. If we know that the supplier requires say 3 weeks notice to meet the delivery dates, is it possible to set the second column to auto-fill based on the first column - 21 days.
Hope that makes sense.
Any help would be appreciated.
Help Article Resources
Check out the Formula Handbook template!