Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 214
  • Last Modified:

Formula to seperate date field

Hi Experts

I have the date in column a row 3 as Dec 20, 2013...
But I would like to show it as Dec 20 only in col B3..
0
route217
Asked:
route217
  • 4
3 Solutions
 
Rob HensonIT & Database AssistantCommented:
Do you want it actually converted to actually hold only day and month in the cell or purely show only the day and month.

The latter can be done easily with formatting, a custom format of "dd mmm" would do it. Apply to either column A or have formula in column B =A3 and then apply formatting to that.

For truncating to only day and month you would use:

=text(day(a3),"dd")&" "&text(month(a3),"mmm")

Thanks
Rob H
0
 
Rgonzo1971Commented:
Hi,

If your date is a date and not a text

=TEXT(A3,"MMM DD")

Open in new window

Regards
0
 
Rob HensonIT & Database AssistantCommented:
Sorry, amendmen to that as it doesn't work:

=TEXT(A3,"dd")&" "&TEXT(A3,"mmm")
0
 
Rob HensonIT & Database AssistantCommented:
Or as Rgonzo1971 suggests but with the format the other way round.

=TEXT(A3,"DD MMM")

Thanks
Rob H
Edit: My bad, Rgonzo had it right way round, apologies.
0
 
Rob HensonIT & Database AssistantCommented:
Along similar lines, correction to custom format suggestion would be "MMM DD"

Thanks
Rob H
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now