Time Sheet End of Month

K

kojak

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

Simple Copy to and From Cells With IF statement. 3
Userform question 4
2016 Project, adding a workday to custom field 0
Week number 1
Days between 2 dates excluding Sundays only 1
Next weekday ... 3
Calculating occupational sick pay entitlement 0
Help to Highlight Excel Row based on Weekly Date Range 2

Top