Pulling of month & year from date cell

Hi all,

i have attached a sheet, i want if i put date in cell a2 and automatically month should come in cell b2 and year in c2,

LIKE JAN AND 2009 LIKE THAT..

pls go throuh my sheet and do help,

and also if it is possible, pls do that i want total of each folder and account in sheet2..

Thanks in advance..

Test.xls

Hi,

To return the month use

=TEXT(MONTH(A2),"mmm")


To return the year use

=YEAR(A2)



To total according to folder, use the SUMIF function. Eg, for Folder 350 Credits minus Debits

=SUMIF(D2:D13,350,G2:G13)-SUMIF(D2:D13,350,F2:F13)

Hi try this

=TEXT(A2,"MMM")
=TEXT(A2,"YYYY")

You don't have a sheet 2

WOW, great..Thanks both of you..,

You are great and kind..God bless you and bewtow you return of this favour..

One thing more, your this formula =SUMIF(D2:D13,350,G2:G13)-SUMIF(D2:D13,350,F2:F13)
is correct..but what i want is in sheet be from column folder all floder name like 350, 458, 230 whatsoever should come in order and their balance should come in front of them and same as from column account should give me same result like account name 45878 and others..

Thanks..

You have several options,

One is to extract unique values from the lists using Data > Filter > Advanced Filter and then modifying the above formula.

Another is to use a pivot table to summarise the data