Time Sheet automatic dates stop at end of month

Hello All,

I am new here, I have some experience with Excel but I come and go like a bad smell, I will have an excel project and once completed it will be years before the next and get a massive amount of skill fade, and thought I would join to get some pointers in areas that are new to me or have forgotten.


I am updating an old copy of a time sheet that has been around for years, every month someone edits the template and distributes it to all staff with the correct dates, I want to eliminate the need for this.

I have made a start so when a user selects a month and year it fills the first date, then a separate formula to create the next date and so on.


My issue is when i get to the last day of the month be it the 28th/30th/31st, I can't work out how to stop the next formula so it will go back to the 1st, using:

Please Login or Register  to view this content.

Is there a way for the formula to recognise this? I have had a google and seem to get lost and don't understand what they are showing.

Thank you for your help in advance.

Nether have worked for me

I have been trying to work it out after your first and what I have so far (But still not working as planned)

Please Login or Register  to view this content.

So If I break this down so you can see my problem now with me;


IF The Date in A32+1's Day is Less then the day in A32 now then enter Blank, otherwise add a day to A32 to equal your cell


What I need to write is if the date in A32 + 1 Day starts a new month then put a blank there otherwise add a day.

I just need to think a little more out side the box

I Finaly got it whoop whoop,

Please Login or Register  to view this content.

couldn't have done it without your help, you started me on the idea and I learnt from it, Thank you

OK now I know that I will work on shortening it, Thanks for the heads up

How would I accomplish this for semi monthly timesheets where I need 16 lines to accommodate 31 day months but want the it to stop at the 15th? I am keying off of a period start date for the timesheet. This solution works for timesheets starting the 16th of the month but ont he timesheet starting the 1st it wfills in through the 16th. Thanks in advance for your help.