AnsweredAssumed Answered

Is there a function that returns the word "DAYS" after evaluating the formula?

Question asked by SReivenhart on Oct 24, 2018
Latest reply on Oct 24, 2018 by SReivenhart

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?

Outcomes