Time Sheet End of Month

G

Guest

I have a worksheet that contains a date that is set by a user for the work
week ending date, which is Friday. From that cell I can populate the dates
for the days of the week on another worksheet, which contains the following
headings
Sat Sun Mon Tues Wed Thur Fri

The dates are then calculated and entered in the cell under each day of the
week. The problem I am facing is the beginning and ending of each month.
For instance MAY 1 falls on a Tuesday this year, I don't want any dates under
Sat Sun or Mon.. The same is true for the end of the month - April 30 falls
on a Monday and I don't want any dates under Tue Wed Thur or Fri.
I would appreciate any help
 
M

merjet

Excel's EOMONTH function should come in handy. Also, adding 1 to it
gives the first day of the next month.

Hth,
Merjet
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Userform question 3
Week number 1
Need Formula to Calculate Time/Overtime (2) 2
Next weekday ... 3
fill weekdays with date 1
Split days of the month if new month begins 2
Insert Date in correct cell 4
Error Handler displaying message when no error 5

Top