Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try this formulae =today()- YearStart(today()).
i think this should help you.
Cheers
- Sridhar
Hi,
Try this formulae =today()- YearStart(today()).
i think this should help you.
Cheers
- Sridhar
It works! Thanks!