Day number of year

[#1]

Hello all,

How do I get the order number of today's day, when it is the 140th day of the year (20/5/2009)?

My purpose is to calculate an annualized number of a product's consumption, when I get the updated YTD consumption every day from ERP:

YTD consumption x 365 / <day number of today> = annualized consumption.

Cheers!

Teppo

[#2 · Accepted solution]

Hi,

Try this formulae =today()- YearStart(today()).

i think this should help you.

Cheers

- Sridhar

[#3]

It works! Thanks!