function for date?

  • Thread starter Thread starter Jorge Cervantes
  • Start date Start date
What do you mean by "the above function did not work"?

What error message did you get? If not an error message, what value did the
formula =TEXT(DATE(2007,11,25),"mmmm dd, yyyy") return? If the cell merely
displayed the formula, rather than the result, make sure that you haven't
got the cell formatted as text; if it is, then format as General, and
either re-insert the formula, or hit F2 to get into formula edit mode and
hit Enter.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Black Friday starts today! 27
Newbie's question abut date function 4
Need help formatting a sheet 0
Conditional formula's in excel-calculating with dates / age andaffiliation date calculus 3
the today's date on my calender has changed. how do I change back 1
Remaining Steam sale dates for 2019... 4
Dark Souls III - DLC out on 25th October 2016 0
Query to sum between specific date And Date() 0

Back
Top