Hello everybody, Is there a way to get the number of the day of the year? Math column DAY (date) only gives the day of the month… Thanks in advanced. Albert

Try this. Round(Date- (((Date+CEILING((YEAR(Date)-YEAR(Date))*365.2424)-DAY(Date)+15)-(MONTH(Date)-1)*30)-DAY((Date+CEILING((YEAR(Date)-YEAR(Date))*365.2424)-DAY(Date)+15)-(MONTH(Date)-1)*30)+1))

[image] date Guide on Dates & Times Community Resources The Date & Time column contains both a date and time value within one single value. Dates and times can therefore be tricky to understand and to work with. It helps to keep things simple to stay out of trouble. Here …

[image] Jeff_Hager: Round(Date- (((Date+CEILING((YEAR(Date)-YEAR(Date))*365.2424)-DAY(Date)+15)-(MONTH(Date)-1)*30)-DAY((Date+CEILING((YEAR(Date)-YEAR(Date))*365.2424)-DAY(Date)+15)-(MONTH(Date)-1)*30)+1)) It worked great. Many thanks! Albert

You don’t need to complexity yourself. Just use the native Luxon format day of the year in the format Date computed column: [1000014213] Today is feb 4th, so 31 days of January + 4 days of feb = 35! :slight_smile:

Many of us are generally not in favor of using the Format Date column because it has a lot of compatibility issues with different devices and different regions. If it works it works, but I would do a heck of a lot more testing to verify the results from Format Date as compared to the Math column. …

Day of the year

Ask for Help

LAM_DO February 3, 2025, 6:26pm 2

You might need it bookmarked. I’d use javascript column and get chatgpt to make it if anything beyound these

Topic		Replies	Views
How to get the day of the current date? Ask for Help	3	253	July 7, 2023
Calculate Current Day of Year Ask for Help	3	47	November 16, 2025
Trouble Linking "Day of year" to Daily Quotes Table Ask for Help	5	20	July 2, 2025
📅 Guide on Dates & Times Community Resources	22	1661	April 2, 2025
Math column computing date Ask for Help	4	255	August 27, 2023

Day of the year

Related topics