I need to write a formula that indicates whether a sensor was on from the beginning of the year until now, with the output rounded to whole days. The output should also be the format of ### of days with the word 'days' included.
i.e. 891 days.
I tried using the Yearday and Day function but I'm not getting the output I need. May anyone please help?