Hi. I'm sure this question has been asked before but I can't seem to find the specific answer anywhere.
I have two date columns formatted with Short Date. Column E is the date we receive the item and Column F is the date the item is due, 14 days from the date of receipt.
I would like to apply a formula to the entire Column F to calculate the Column E date plus 14 days, keeping in mind that most of Column E is blank but will be filled in as we receive the items. In other words I would like Column F to automatically fill in the due date once I enter the received date in Column E.
If anyone could help me out I would be infinitely grateful.
Thanks.
Bookmarks