Thank you this was just what I needed to get the short date I wanted

@ChrisMenardTraining

14 күн бұрын

Glad to help!

Chris, you rock!! You are to the point and quick. 5-STARS

Always learn something from your videos.

@ChrisMenardTraining

2 жыл бұрын

Thank you, Keeley! That is good to know.

Thos was an awesom tutorial. Thank you

Thank You Very Much🤩

exactly what I needed to know

great tips - thank you

@ChrisMenardTraining

2 жыл бұрын

Glad it was helpful! Thanks, Brent.

Brilliant, saved my day.

@ChrisMenardTraining

Жыл бұрын

Thanks, Eric.

Great job! I can now get a day Infront of my dates :-)

Helpful, thanks

@ChrisMenardTraining

Жыл бұрын

You're welcome!

Thanks from India

@ChrisMenardTraining

Жыл бұрын

You are welcome from Atlanta!

such a great video, but I have a question can be write the months and date in caps

Thank you sir

@ChrisMenardTraining

2 жыл бұрын

Welcome

Very useful. One question though. I want the default date when I use the Control Colon option to be in the following format. dddd, MMMM d, yyyy Sunday, January 8, 2023 How do I do this?

Thank you

@ChrisMenardTraining

Жыл бұрын

You're welcome

Hi Chris, I have a coulum of merged cells with a custom format date, which i need to stay centre of the column. I have the day name on top, I've then used ALt0010 to drop the rest of the date so it displays below the named day, however this then doubles the cell's width. Is there anyway I can stop the cell width doubling? Thanks Mark.

THANKS

@ChrisMenardTraining

9 ай бұрын

You're welcome!

Chris - I now this is beyond date formatting.... If I have a column with "JUN 11-12' how can I divide that up to 2 columns with '6/11' and '6/12' ?

Thanks for your videos and clear explanations.. Why is the US illogical by writing dates as Month/Day/Year? Day/Month/Year is so much more sensible. It's the same illogicality of still using the Imperial System rather than the System Internationale.

Nifty tricks

@ChrisMenardTraining

2 жыл бұрын

Thank you!

Hi, I have one question, I want a date format with only the and the year, how can I do that?

Is there a way to change the data to get only one date per month on dates?

Hi! i have a problem. I used to be able to type dates like this 6 11 2023 and Excel would read it as a date and when i click long or short date it follows format. now it doesnt. I had to get my laptop reformatted and got the new windows and offices so im still figuring out all the issues in regards to my preferences. it only reads 06/11/2023 as dates and this just annoys me because it wasnt a problem before. thank you so much

I pasted a number of dates. For instance 1988-3-24. Plus maybe 10 down with different ones. I want this to be 3/24/1988. Different cell. Same for others. I have done this all under cell formatting. It will not let me change the format. Everything stays exactly the same. What can I do to make this work.

thank you for the video. I have a column with random date started in the midle of the week and I need weekend dys to be colored in different color automatically, to be easily indicated after that. Could you advise me how I could do, please?

@ChrisMenardTraining

6 күн бұрын

One easy solutions is to add a helper column, a new column. In that column type =Weekday(a2) as an example. Conditional formatting based on the 1 and 7. drive.google.com/file/d/1nXaYIbInOc0yWmmjYOL4G8EmNa-65gY4/view?usp=drivesdk

but what if my sample is not a number, but pre-witten as a date? it began saying 1/9/2023 (January, perse)-- now I wanted to change it to 09/01/2023 and it doesn't do anything when I format it, still shows the same

Is it necessary to format a date to year only? I am certainly experienced with excel; however, I have never been able to format a number to be yyyy only (2024 or 1976, for example).

Hello Chris, I'm wondering is there a way to do custom formatting but to get the last day of the month.

@ChrisMenardTraining

Жыл бұрын

EOM Function. If A1 contains 8/4/2023, in B1 type =EOM(A1,0) and that will give you 8/31/2023

How to create a custom date format which only gives mm/yy. Example expiry date of a medicine..

I want to input 01022024 and have it automatically correct to 01/02/2024. How do I accomplish this?

Ages ago, when Excel allowed you to actually customize, I was able to set the date to auto add in a specific year. Meaning, I want the same year to show up in the column where I'm adding dates. I have nearly 1,000 entries to make, on each sheet, so not having to type the year on that sheet would be great! I used to be able to customize with mm/dd/2022. Then type in 03/21, but it would show 03/21/2022. The next sheet I could customize it to whatever year I was working on that page mm/dd/2023. Unfortunately, it's not allowing me to do any of that now. :( Is there a way to customize the date in such a manner?

@BentleyLittleman

6 ай бұрын

I'm trying to do the same. When I try to format to year using =if or custom, my date will change to 1905 (yes, I understand the concept of 1905 lol)

Hi Chris, how do i pre set date to be the same format no matter how i type it in?

@AjayMenonPHOTOARTIST

Жыл бұрын

What is your preferred choice of date? There is a way to do this in the Control Panel, Regional Settings. Some predefined choices for Short Date is helpful but it didn't have my choice of day but it may work for you.

Hello, how can I make Friday, 08/05/2022 to look like : Friday 08/05/2022

@ChrisMenardTraining

2 жыл бұрын

Here is one way. Will this work? There is another way. drive.google.com/file/d/154bqp_r95JTHGSG5agL9d7SqY-wIH1br/view?usp=drivesdk

Nothing to add this time 😂

@ChrisMenardTraining

2 жыл бұрын

Thanks.