Ask Your Question

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

asked 2019-10-07 18:02:39 +0100

Windcheetah gravatar image

updated 2019-10-11 17:38:47 +0100

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.

If that is not clear, please leave a reply, and I will try and explain again.

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


Thanks loads


edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2019-10-07 18:35:04 +0100

Opaque gravatar image

updated 2019-10-07 22:48:02 +0100


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 ...


Hope this helps.

edit flag offensive delete link 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

Windcheetah gravatar imageWindcheetah ( 2019-10-07 18:46:09 +0100 )edit

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

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

No problem, thanks for your help Martin

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

If the answer solves your problem click the check mark (✔) next to the answer. Thanks in advance.

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

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

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

answered 2019-10-07 18:56:18 +0100

Windcheetah gravatar image

updated 2019-10-11 17:34:33 +0100

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

edit flag offensive delete link more


And which additional information does this additional answer provide?

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

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

Windcheetah gravatar imageWindcheetah ( 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.

Opaque gravatar imageOpaque ( 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.

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

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

Windcheetah gravatar imageWindcheetah ( 2019-10-11 17:37:37 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-10-07 18:02:39 +0100

Seen: 69 times

Last updated: Oct 11 '19