how can I display the date from a number of seconds given?

L

Lady Lexly

As the expression: =Format(Now(), "y") displays the number of the day of the
year the current date represents, where y is 1 through 366.... I need the
antonym funtion of this, in order to get a date from a specific number of
seconds given.
Could somebody help me on this matter?
Thanks in advance for your help
 
R

Rick B

A date from a number of seconds given? Huh?

If I tell you "120 seconds", what date would you expect to see?

I don't understand the question.
 
R

Rick B

Aha! sounds like you want to know the number of seconds from the beginning
of the year. It seems to me that there are 86,400 seconds in a day, so take
whatever they give you and divide by 86,400. That will give you the number
of days. I am still not sure how to return a DATE though. Since I am not
sure where your starting point would be.
 
Top