View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
86 86 is offline
external usenet poster
 
Posts: 3
Default Day/Date formula

Is it possible to have a function where if you enter the date numerically, eg
'30/3/7'
it returns the DAY & date, eg 'Fri, 30th March 2007' ?

This would obviously work off the computer calander so as to ensure it gets
the day of the week correct.

Thanks