how do i bring up teh days of of a month across columns. whatever todays'
date be, the formula should just check which month we r and should display
the dates. for eg., when we r in 29/1/2008 the cell should recognise that we
r in month jan and display dates from 31st dec to 3 rd feb(in calender the
first workday of teh month (monday) begins on 31st dec 2007 and the last
sunday of the month is feb 3rd).
so when im in feb, i should get dates from 4th feb to 2nd march. and for
march month it shud be as 3rd march to 30 th march etc till dec.
I should overwrite jan dates by feb dates and when in march my feb dates
should be overwritten by march dates.

In row 2 of teh sheet : from col F to AN
31-Dec-07 1-Jan-08 2-Jan-08 3-Jan-08 4-Jan-08 5-Jan-08 6-Jan-08

like the above eg., 31st dec 2007 starts at column F and this jan month
dates get filled till column AN and when its feb month it shud fill from
column F till column AK