Dear Mahesh,
Please find attached soluation
Thanks
Sachin Shukla
On 1/13/10, Mahesh wrote:
>
> Dear Friends,
>
> I need your help,
>
> I have to prepare the monthly Reports in which the heading contains the
> name of last month.
>
> For Example:-
>
> 1. If I am preparing report in Ja
hi mahesh
this will help u
="For the month of "&" "&TEXT(EOMONTH(TODAY(),-1),"mmm,")
On 1/13/10, ankur wrote:
> hi mahesh
>
> Sorry for geting your question wrongly, my answer will get only present
> month.
>
> On 1/13/10, ankur wrote:
>> hi mahesh
>> write this formula in your coloum head
hi mahesh
Sorry for geting your question wrongly, my answer will get only present month.
On 1/13/10, ankur wrote:
> hi mahesh
> write this formula in your coloum heading
>
> ="For the month of "&" "&TEXT(TODAY(),"mmm,")
>
> for any more clarification , u can mail me
>
> On 1/13/10, Mahesh w
hi mahesh
write this formula in your coloum heading
="For the month of "&" "&TEXT(TODAY(),"mmm,")
for any more clarification , u can mail me
On 1/13/10, Mahesh wrote:
> Dear Friends,
>
> I need your help,
>
> I have to prepare the monthly Reports in which the heading contains the name
> of
Hi Mahesh,
You can use the formula =DATE(YEAR(NOW()),MONTH(NOW())-1,DAY(NOW())) &
change the format of the cell by following below steps.
GO to format cells--->Custom-->"For the month of" -yy--->Click Ok..
Attached is the solution for your reference. Let us know if it helps you.
Thanks and
Dear Friends,
I need your help,
I have to prepare the monthly Reports in which the heading contains the name
of last month.
For Example:-
1. If I am preparing report in January then heading will be “For the
month of December, 2009”
2. If I am preparing report in February then head
