View Single Post
  #1   Report Post  
jenniferm
 
Posts: n/a
Default specific date function


Hi All,
I am a new user. I would like to present my scenerio in hopes of
getting a formula figured out.

I have three columns.

The first column represents a due date (mm/dd/yy)

the second represents todays date.

In the third column I would like to have the number of days between the
two.

In other words, say the due date was 10/01/05 and today's date column
says 09/20/05, I would like the third column to compute: 10 (for 10
days remaining until 10/1).

Also, the due date might be the following year, so would still need it
to work in that case.

Thanks for any help in advance,
Jenn


--
jenniferm
------------------------------------------------------------------------
jenniferm's Profile: http://www.excelforum.com/member.php...o&userid=27414
View this thread: http://www.excelforum.com/showthread...hreadid=469253