|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.