yes, but you probably do not need the Date value if the cell if formatted as
a date

"BEEZ" wrote:

Hello I am trying to create a 2 or 3 sheet workbook that will let me enter
tasks and dates much like a set up to a gantt chart. with the first sheet.....
Job: Task start date end Date Days to
completion
Submission 08/08/05 08/13/05 47 days to go

For the Days to completion column I am trying to use
=DATEVALUE("11/09/2006")-TODAY()&" days to go" , Is there a way to Vlookup
the "11/09/2006" portion of this formula. From whatever is entered in say
column (C#).

Then on a seperate sheet list Vlookup all the items that are under a
certain number of days left as a priority list to check up the status of
tasks.