Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

How to set date from sheet 2 in a timesheet in sheet 1

0

I have created a timesheet in sheet1 and I intered months in sheet2. I linked it with combo box in sheet1. Now when I click a month the date start with number of month not with the first day of the month. For example when I click the month of March, the date starts from third of march, when I click the month of April, the date starts form fourth of April not from first April.

I request you if you have any formula to resolve the problem.

Thanks

Answer
Discuss

Discussion

It isn't possible to correct your formula - if it is wrong - because you didn't publish your formula. You should tell us where you want the date.
However, I suspect that your problem isn't with the formula at all. It might be with your date format. If your computer is set to use American (or perhaps your formula or code) dates the format would be Month/Day/Year while English dates are written Day/Month/Year. The juxtaposition of the month might be caused by your PC settings. Look at the Regional Settings.
Variatus (rep: 4889) Jul 24, '17 at 11:08 pm
Add to Discussion

Answers

0

Try this file

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login