View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Formula for Created on Date

Try this one-line UDF:

Public Function creation_date() As String
creation_date = ActiveWorkbook.BuiltinDocumentProperties("Creation Date")
End Function

--
Gary''s Student - gsnu200757


"Joe M." wrote:

I am trying to automatically insert the file created on date in a cell. Is
there a formula to do this?

Thanks,

Joe M.