Date Calculation from a Due Date
 

On Tue, 29 Nov 2005 13:52:02 -0800, Prabha
wrote:

Hi all,
I have a project table with due date in cell A4. In cell A5, I require to
have it calculate, the number of days/months remaining till the Due Date.

I haven't been able to find the answer by Googling. There are solutions for
calculations between 2 dates and so on.

Your advise would be very much appreciated, as I require to prepared this by
the end of this week.

Many thanks in advance.

Prabha

A5: =A4-TODAY()

will give the number of days remaining from today until the due date.

Format A5 as General (Format/Cells/Number/General)


--ron