excel formula to calculate date

August 12, 2011 at 00:43:00
Specs: Windows XP, dual core 2
In my sheet I want to implement day as numeric value and will show for the month and month font should be displayed as text and capitalized and Sundays will automatically be highlighted by red color.
this is to prepare a sheet with the days of the month be calculated automatically every month.
pls pls help.

See More: excel formula to calculate date

Report •

August 12, 2011 at 00:52:23
for example,
=text(today(),"mmmm") will show the month as "August" (want this should be in capital font)
and from next rows it will start displaying the value as followings:
row: A1 B1 C1 ... to z1
value: 1 2 3 ,,, to last day of the month (i.e. if it is Jan then 31 if Feb then 28/29 etc.) Sunday font color should be red colord.
Not willing to use macro/vb.

Report •
Related Solutions

Ask Question