I am creating a interactive calander for appointment scheduling.

The last three days of the month vary depending on month, I have used a
combination of two date commands to forcast the next month. I use the
=TODAY() command to get the current month, then use the
=DATE(YEAR(cell),MONTH(cell)+1,1) refence the TODAY command to forcast
the next month.

What I want, is to make the 29th, 30th & 31st conditionally formated. I
know I know how to do conditional formating for the cell givin a certian
value, but I don't know how to bring data from outside the cell to meet
the formating I want.

For instance, I would like to have an IF command that gives the value
of 29 for the months that contain the 29th day, and like wise for the
other days of other months.

Once I know how to retrieve the data I want, I already know how to
format the cell.

The help is greatly appreciated.


--
IDCrewDawg
------------------------------------------------------------------------
IDCrewDawg's Profile: http://www.excelforum.com/member.php...o&userid=27009
View this thread: http://www.excelforum.com/showthread...hreadid=420861