U
uwajes
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:
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: