asked on

Calendar is not populating dates on the correct day

Here is my second question to:

https://www.experts-exchange.com/questions/28141375/Move-specific-cell-data-to-another-worksheet-and-range-name-in-MS-Excel.html

In my calendar, the dates don't seem to be aligning correctly when I select a month from my validated drop down box. Calendar won't do much if its not correctly showing the correct days to each date. Attachment is below. Thanks again
Calendar.xlsm

[ fanpages ]

Hi,

I have resolved the compilation issue(s) you were experiencing.

Please refer to the updated workbook attached to the following comment:

[ https://www.experts-exchange.com/questions/28141375/Move-specific-cell-data-to-another-worksheet-and-range-name-in-MS-Excel.html?anchorAnswerId=39206455#a39206455 ]

BFN,

fp.

Southern_Gentleman

ASKER

Thanks Fanpages, I'm still having the issue of having the calendar not having the dates fall on the correct day. For some reason when I do a check, July 2013 is 2 days ahead. All the information from my table is going in the correct box but the label of the date is not coinciding correctly.
Q-28141375.xlsm

Southern_Gentleman

ASKER

I've requested that this question be deleted for the following reason:

I found my solution

Norie

Could the problem be something to do with the calendar being a bit out?

For example, the first day of July 2013 is on a Monday, not a Saturday.

How are you working out the weekday for the first day of the month?

[ fanpages ]

Thanks Fanpages, I'm still having the issue of having the calendar not having the dates fall on the correct day. For some reason when I do a check, July 2013 is 2 days ahead. All the information from my table is going in the correct box but the label of the date is not coinciding correctly.

You're welcome.

No, I didn't look at the issue with the Calendar, but I see imnorie has addressed that in the comment below:

[ https://www.experts-exchange.com/questions/28142526/Concatenate-fields-into-calendar-date.html?anchorAnswerId=39206779#a39206779 ]

I have requested attention from the site's Moderators to resolve the allocation of points so that you do not double-up/waste points accepting two threads.

Norie

Can someone clarify to me where I should actually be posting?

I posted the code for fixing the dates in the other thread by mistake.

I was just about to take a look at the problem with the details on the calendar and the concatentation thing.

[ fanpages ]

imnorie:

Can someone clarify to me where I should actually be posting?

Sorry, I cannot help you. I asked for clarification by requesting attention, but I am even more confused now! :)

Norie

Same here.

I was just going to start looking at the problem as well.

Oh, wait a minute, I don't really know what I should be looking at.:)

ASKER CERTIFIED SOLUTION

Norie

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial