Excel: auto-calculate a date 2 weeks after an initial date

S

sffan2004

I'm setting up a spreadsheet to track books being loaned out by my dept and I
would like Excel to automatically calculate the Date Due after I enter the
Date Checked out. I am uncertain how to write the formula.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1
First row where a cell is zero 2
Date Functions 5
Calculating an average of data between two dates 1
Enable Iterative Calculations 0
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Change Color of Cell based on Date and today's date. 1
calculate a date, 10 weeks after a set date & return a specific da 2

Top