Hats off to all the kind members of this forum. This is a very helpful forum. I am overwhelmed by the willingness of the
members to help.
I am very new to Excel and I may not be using the proper technical terms in my question. I am
trying to explain in layman terms.
I want to create a monthly timesheet which contains 9 columns for
(Date, Day, Project no., Activity, Time In, Time Out, Total Hours, OT Hours, Remarks)
I have used IF Function to
calculate Total Hours & OT hours automatically. Time IN & Time OUT, Project No., will be entered manually on daily basis.
Weekday function is used in the Day column to return the corresponding day of the date in the Date column.
Name of the Month and Year will be manually entered in the designated cells I3 and I4 respectively.
solution I am looking for is, the dates should be automatically entered in the Date column (in cells A8 to A38) based on the
Month & Year entered in cells I3 & I4. Dates of the corresponding month of the year should only be filled in. (If a month is
not having 29, 30 or 31st day, the corresponding cells should be left blank. i.e. nothing should be displayed in the
corresponding cells). I am looking for some sort of formula to enter in the cells of Date column (A8 to A38) achieve this. I
have searched the forum and could not find anything which could at least give me an idea about the kind of function or
formula to be used.
Attached here is the time sheet I am trying to create.
Thanks to all.