# of days since Jan. 1

  • Thread starter Thread starter mate
  • Start date Start date
M

mate

i want to use the number of days since Jan. 1 first in an
equation. Is there an expression to calculate this? any
help is greatly appreciated. Thankyou.

mate.
 
DaysPast: Date()-#01/01/04#


Will tell you the number of days between today and Jan 1.

Rick B



i want to use the number of days since Jan. 1 first in an
equation. Is there an expression to calculate this? any
help is greatly appreciated. Thankyou.

mate.
 
For the current date of the current year, you can use the formula below.

DateDiff("d",DateSerial(Year(Date()),1,1),Date())
 
i want to use the number of days since Jan. 1 first in an
equation. Is there an expression to calculate this? any
help is greatly appreciated. Thankyou.

mate.
Click to expand...

One question, several solutions: yet another is

Format(Date(), "y")
 
Back
Top