Calendar

A

Ajit Munj

I want Excel to show days like Sun,Mon,Wed in Row2 and below that dates like
1,2,3 if I put a particular month and year in cell a1 e.g. if in cell a1 i
put Oct 2007, Excel should show Mon, Tue, Wed in row2 and below that 1 upto
month end in row3. At the same time, Excel should colour all values in RED
below Colum Sunday. How can I ahieve this?
 
A

Ajit Munj

sorry, it didn't help me. I want excel to fill the days and dates
automatically
when I change the month in cell a1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting day names chronologically 5
Payroll 1
Macro or Formula 5
How to Auto fill dates on a schedule 3
Days in Calender 5
Naming Of A Day In The Month 9
Name The Day Of The Date2 5
Conditional Sum 1

Top