# Too Many Days in Month when less than 31 (Solved)

Hi, I'm trying to create a planner for a number of months. They are down the left hand side, with the days across the top. As the number of days in the month change, the days across the top can extend for too long, as there are 31 columns in the sheet.

The attached file shows the problem that I'm trying to solve.

Martin

edit retag close merge delete

Sort by » oldest newest most voted

Hello

not sure whether I got your problem right, but please check the modified file using - starting in cell C1 - the following formula:
=IF(AND(B1<>"";DAY(B1+1)>DAY(B1));B1+1;"") and so on ...

C:\fakepath\PlannerModified.ods

Hope this helps.

more

Hi, thanks loads, at an initial look, it looks topps!!!! Could you possibly send a link as to where gives you a hint as how to do it?? Martin

( 2019-10-07 18:46:09 +0100 )edit
1

A link to what? I cannot provide a link to my brain (and if I could, I wouldn't).

( 2019-10-07 18:51:30 +0100 )edit

No problem, thanks for your help Martin

( 2019-10-07 18:57:34 +0100 )edit

( 2019-10-07 19:09:40 +0100 )edit

Wonderful, I'm sorry about messing up the forum.

( 2019-10-11 17:36:32 +0100 )edit

I have removed the answer that was here, as mistakenly thought it was the place for what I thought the best answer was. Sorry

more

( 2019-10-07 19:08:07 +0100 )edit

Sorry, I thought this is where I put what I consider the best answer.

( 2019-10-07 19:14:05 +0100 )edit

No - clicking the check mark (as you already did - thanks for that) is the way to indicate what you consider the best answer.

( 2019-10-07 19:17:12 +0100 )edit

@Windcheetah You used the Propose Your Solution edit pane, which is meant for adding possible ways to solve the issue presented. Your entry added nothing to the solution already given by Opaque.

Most likely you meant to comment on that solution. You could have done that by adding a comment (the yellow "Add a comment" speech bubble/plus sign icon below their answer). It is not really needed, because clicking the checkmark (which you or an admin/mod did) essentially says the same thing, but most likely it would be appreciated.

Upvoting (click the up arrow over the "score" for the answer) is another easy way to "comment" on the quality of the answer without actually posting a comment.

( 2019-10-11 14:14:39 +0100 )edit

Thanks for the info, I hope I've corrected my errors

( 2019-10-11 17:37:37 +0100 )edit