View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Last Saved Date Formula / Function

Bearacade wrote:
I tried the code and it works perfectly fine...

What formating do you have for the cell that is pulling up the fuction?
I used the date and time stamp.

[$-409]m/d/yy h:mm AM/PM;@

I reverted back a month, saved the spreadsheet, opened it up and called
the function and it was giving me the correct time and date.
--
Bearacade


This is my formatting on the cell:
m/d/yyyy h:mm

Can I ask what "called the function" means? Does this mean something
has to be manually done to the function, and that it won't work
automatically?