Thread: how do i split a cell that contains dd/mm/yy into a 3 separate cel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
  
Posts: 1,316
Default how do i split a cell that contains dd/mm/yy into a 3 separate cel
This extracts the year from a date
=YEAR(DateValue)

This extracts the month from a date

=MONTH(DateValue)

And just in case, this extract the day

=DAY(DateValue)
--
Kevin Backmann


"Eva" wrote:

I have a column that contains a list of paid invoices and the payment date is
showing as dd/mm/yy. I need to do a pivot by month. How do I change my cell
from the current format so the month is shown in one cell and the year in the
next cell?
Reply With QuoteReply With Quote