Glad to hear it. Thanks for the feedback.

Fred.

"TUNGANA KURMA RAJU" wrote in
message ...
Thanks,
Fred ,its working.

"Fred Smith" wrote:

Why don't you test it out to see if it works. Then we'll work on your
second
question. I expect you'll find if the formula works for the current
fiscal
year, it won't be too hard to change for the previous year.

Regards,
Fred.

"TUNGANA KURMA RAJU" wrote
in
message ...
thanks,I haven't tested the function;
What about my second question?

"Fred Smith" wrote:

One way:

=sumif(a:a,""&date(year(today())-1,3,31),b:b)-sumif(a:a,""&date(year(today()),3,31),b:b)

Regards,
Fred.

"TUNGANA KURMA RAJU"
wrote
in
message ...
I have a dates in ascending in Col-a, and income amount in col-b.
I need a function that gives me --sum of income earned in this
financial
year as on today.(assuming financial year 1st april to 31st
march).No
where
the financial year is entered in w/sheet.basing on today's date the
fuction
should calcualte financial year,and other results.
second part of question is -what will the function for last
year,basing
on
today'date.