Thanks Deba. Its very nice even before using it I never know that Excel
could do all these stuff so nicely.
Thanks again Dear.
On Tue, Jul 17, 2012 at 9:44 AM, Deba Ranjan <drdeva...@gmail.com> wrote:
> Dear Mangesh,
>
> To create this calendar in the range B2:H9, follow these steps:
>
>
> 1. Select B2:H2 and merge the cells by choosing Home ➪ Alignment ➪ Merge &
> Center.
>
> 2. Enter a date into the merged range. The day of the month isn’t
> important.
>
> 3. Enter the abbreviated day names in the range B3:H3.
>
> Performing Magic with Array Formulas
>
> 4. Select B4:H9 and enter this array formula. Remember: To enter an array
> formula, press
> Ctrl+Shift+Enter (not just Enter).
>
> {=IF(MONTH(DATE(YEAR(B2),MONTH(B2),1))<>MONTH(DATE(YEAR(B2),
> MONTH(B2),1)-(WEEKDAY(DATE(YEAR(B2),MONTH(B2),1))-1)+
> {0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),””,
> DATE(YEAR(B2),MONTH(B2),1)-(WEEKDAY(DATE(YEAR(B2),MONT
> H(B2),1))-1)+
>
> {0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)}
>
>
> 5. Format the range B4:H9 to use this custom number format: d. This step
> formats the
> dates to show only the day. Use the Custom category in the Number tab of
> the Format
> Cells dialog box to specify this custom number format.
>
> 6. Adjust the column widths and format the cells as you like.
>
>
> 7. Change the month and year in cell B2. The calendar updates
> automatically.
> After creating this calendar, you can copy the range to any other
> worksheet or workbook.
>
>
>
>
> Thanks & Regards,
> *Deba Ranjan P*
>
>
> ****
>
>
> On Mon, Jul 16, 2012 at 4:56 PM, Mangesh Vimay <mangesh.da...@gmail.com>wrote:
>
>> Please tell us so that we can edit and learn it. How to make ?
>> calender_Simple.xls file
>>
>>
>> On Fri, Jul 13, 2012 at 11:05 AM, NOORAIN ANSARI <
>> noorain.ans...@gmail.com> wrote:
>>
>>> Dear Manoj,
>>>
>>> Please find attached simple Calender.
>>>
>>> You can create it simply.
>>>
>>> On Fri, Jul 13, 2012 at 10:04 AM, Manoj Kumar <
>>> kumarmanoj.11...@gmail.com> wrote:
>>>
>>>> Dear Expert,
>>>>
>>>>
>>>> I want to make Calender on excel....
>>>>
>>>> when i enter year & month in a coll it show me date wise calender...
>>>>
>>>>
>>>>
>>>> Regard
>>>> Manoj
>>>>
>>>> --
>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>>
>>>> 2) Don't post a question in the thread of another member.
>>>>
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>>
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>
>>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>>> signatures are prohibited.
>>>>
>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>> Forum owners and members are not responsible for any loss.
>>>>
>>>>
>>>> ------------------------------------------------------------------------------------------------------
>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>
>>>> To unsubscribe, send a blank email to
>>>> excel-macros+unsubscr...@googlegroups.com
>>>
>>>
>>>
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>> www.noorainansari.com
>>> www.excelmacroworld.blogspot.com
>>>
>>>
>>>
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> ------------------------------------------------------------------------------------------------------
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>>
>>
>>
>>
>> --
>> With regards,
>>
>> MaNgEsH
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> ------------------------------------------------------------------------------------------------------
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
> --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> ------------------------------------------------------------------------------------------------------
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>
--
With regards,
MaNgEsH
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
