calculate day

  • Thread starter Thread starter Irene
  • Start date Start date
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!
 
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)
 
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...
 
Back
Top