Thread: extract character from date format & no of days between date

Hi,

I have two questions regarding date format and hope you can provide input.

1) say 01/01/2010 displays as Jan-10 and i need a new column to state it as JAN. What function should i use to achieve it?

2) i need to state the difference between first day and last day of the month. What function should i use to achieve it?

Thanks in advance for you guys help.

Re question 1 - either:

a) =A1 format as MMM

b) =TEXT(A1,"MMM")

Re: question 2 - either:

a) =DAY(EOMONTH(A1,0))

b) =DAY(DATE(YEAR(A1),MONTH(A1)+1,0))

use of EOMONTH requires activation of Analysis ToolPak pre XL2007

1) right click on the cell -> Format cells -> custom -> (write in) mmmm (for January) or mmm (for Jan)

2) try this formula =DATE(;MONTH(L28)+1; )-DATE(;MONTH(L28); )

Replace ; with , if needed