MrExcel Publishing
Your One Stop for Excel Tips & Solutions

counting days until a date

Posted by Terri on October 26, 2001 1:49 PM

I am working on a spreadsheet and need to calculate a
function I am not sure if it can be done. What I need to
do is have a start date then count for example 141 days
and have it tell me what that date would be.

Any Suggestions??

Posted by Aladin Akyurek on October 26, 2001 2:02 PM


where A1 houses the start date. If you wish, you can put 141 in a cell and the ref of that cell in the above formula instead of 141.