calculate day

I

Irene

i want to make a query that calculate the day. can anybody tell me how to
calculate how many days still left from now til end of the month. thanks!
 
A

Allen Browne

The last day of this month is:
DateSerial(Year(Date()), Month(Date()) + 1, 0)

So the number of days left is:
Date() - DateSerial(Year(Date()), Month(Date()) + 1, 0)
 
I

Irene

yes, it works! Thanks a lot.

Allen Browne said:
The last day of this month is:
DateSerial(Year(Date()), Month(Date()) + 1, 0)

So the number of days left is:
Date() - DateSerial(Year(Date()), Month(Date()) + 1, 0)
Click to expand...
 
Top