I'm working on an expense report that will have a sheet for each week.
There will be 7 columns for the 7 days for each week. And up to 5
sheets for up to 5 weeks per month. In the first sheet, I'd like for
the title of the cell in each column to be the date (Mon., 5/1/06).
However, if the first day of the week is on Monday as it was for May,
then I don't want anything in the Sunday column. Make any sense?

Anyway I can do this with a formula?

I can come up with the first day of the month fine
Code:
--------------------
=DATE(YEAR(NOW()),MONTH(NOW()),1)
--------------------
just can't come up with an IF function to put it in the appropriate
column.


--
uwajes
------------------------------------------------------------------------
uwajes's Profile: http://www.excelforum.com/member.php...o&userid=13424
View this thread: http://www.excelforum.com/showthread...hreadid=538067