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))

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
Get the days of the current month Ask for Help	11	94	October 17, 2024
How to get the day of the current date? Ask for Help	3	237	July 7, 2023
Convert Date to Day of the month or week Ask for Help	4	727	April 6, 2023
Been asked before, but... How do I add a day to a date column? Ask for Help	3	40	July 17, 2024
📅 Guide on Dates & Times Community Resources	22	1097	April 2, 2025

Day of the year

Related topics