Add dates and find difference

[Guest]

I have two fields [Date_of_File] and [Number_of_Days_To_Work] that I need to
add and then find the number of days left to complete. Basically do the
following:
([Date_of_File]+[Number_of_Days_To_Work])-Today(), but cannot get this to
work. Thank you!!

 

[Douglas J Steele]

Access doesn't have a Today function: it has Date() (which returns just the
date) and Now() (which returns the date and time)

 

[Bill Edwards]

=DateDiff("d", Date, Date_of_File + Number_Of_Days_To_Work)