# of days since Jan. 1

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.
 
R

Rick B

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.
 
J

John Spencer (MVP)

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

DateDiff("d",DateSerial(Year(Date()),1,1),Date())
 
J

John Vinson

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")
 
Top