Hi Martin,

Thanks for the wonderful solution. Its working very fine.

Moreover if this can be done through Macro it would be very benificial
for us.

I want that as soon as the User presses a shortcut key in Excel then
the system should prompt for the Month & the year and as soon as the
user enters January 2007 then the system should generate track dates of
a month except Sunday.

Is it possible.

Pls do help me in this regards

Akash Maheshwari



On Dec 30, 2:09 pm, Martin Fishlock
wrote:
Yes it is try the follwoing code:

[B1]=DATE(2007,1,1)+IF(WEEKDAY(DATE(2007,1,1))=7,1,0)
[B2]=B1+IF(WEEKDAY(B1,1)=7,2,1)

and then copy b2 down for the year.

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.

"Akash" wrote:
Hi,

Is this possible to track dates of a month except Sunday by running a
macro.

Akash