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


=DATE(YEAR(A1),MONTH(A1),DAY(A1)+141)

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.

Aladin