Date function question - number of seconds after a certain date?

[Michael Bourgon]

I'd like to be able to add the number of seconds to a known date,
giving me the current date. In SQL I'd do this:

select dateadd (second, 1715829, '20040803 14:07:08')

What would the Excel equivalent be?
Many thanks.

 

[Frank Kabel]

Hi
try
=A1+1715829/(24*60*60)

where A1 stores your current date/time.