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.
Solved! Go to Solution.
Maybe
HOUR([Date]- EOMONTH([Date], -(MONTH([Date]))))/24
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |