How to the get day of the year

AppSheet AppSheet Q&A
,
1

Hi i want to get day of the year in a particular column… can you pls help me out with the expression.

For Example 19th June 2021 is 170 th day of year. i want 170 as the answer in the column.

2

Maybe

HOUR([Date]- EOMONTH([Date], -(MONTH([Date]))))/24

2 Likes