days remaining and days that have past

[Michael]

I need to computer how many days left and how many days have past in a time
period. I have a start date and an enddate. I am using a short date format
20-6-2005.

can I use allen browns formula for time and change it to the following to
get the days that have past?
Days: DateDiff("n", [StartDateTime], [EndDateTime])I have no idea on how to
get the remaining daysthanks for any help.
Michael

 

[Allen Browne]

Michael, take a look in the help file for DateDiff().
(You do know you have a help file, right?)

Hints:
1. d is for day.
2. If you want days and fractions of a day, there are 1440 minutes in 1 day.

 

[Michael]

Thanks Allen, I looked in the help, but was not able to understand how to do
what I need, but thanks for your comments.
Michael

Michael, take a look in the help file for DateDiff().
(You do know you have a help file, right?)

Hints:
1. d is for day.
2. If you want days and fractions of a day, there are 1440 minutes in 1
day.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I need to computer how many days left and how many days have past in a
time period. I have a start date and an enddate. I am using a short date
format 20-6-2005.

can I use allen browns formula for time and change it to the following to
get the days that have past?
Days: DateDiff("n", [StartDateTime], [EndDateTime])I have no idea on how
to get the remaining daysthanks for any help.
Michael

 

[Michael]

=DateDiff("d";Now();[EndDate])

was the answer for anyone looking for the answer