View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default How can I put in Date & have the Day come up

On Sat, 29 Dec 2007 18:07:00 -0800, Mike Rogers <Mike060349@NoxSpamxAOLDOTcom
wrote:

Rick

Is there a significant difference between your response and that of RagdyeR?

Mike Rogers


Mike,

Rick's response results in the TEXT of the date being returned.

Ragdyer's response leaves the date unchanged (it will still be a number) but
merely changes the formatting.

Ragdyer's method results in a value you can use in date calculations.
Rick's method results in a text string you can use in text manipulations.
--ron