- #HOW DO YOU INSERT CURRENT DATE IN EXCEL 2013 FULL#
- #HOW DO YOU INSERT CURRENT DATE IN EXCEL 2013 WINDOWS#
To change the color of the weekends, open the menu Conditional Formatting > New Rule Assume that you have the date table–a calendar without conditional formatting: When you design an automated calendar you don’t need to color the weekends yourself. With the conditional formatting tool, you can automatically change the colors of weekends by basing the format on the WEEKDAY function. If you need to create rules for other dates (e.g., greater than a month from the current date), you can create your own new rule.īelow are step-by-step instructions for a few of my favorite conditional formats for dates. These 10 date options generate rules based on the current date. You can select the following date options, ranging from yesterday to next month: Home > Conditional Formatting > Highlight Cell Rules > A Date Occuring. To find conditional formatting for dates, go to Get Excel The basics of conditional formatting for dates
#HOW DO YOU INSERT CURRENT DATE IN EXCEL 2013 FULL#
Often now I type it in full because it is faster than to search and hope.Turn data into insights. So I am living with three kind of surprise options. So I understand that the Microsoft guys have some problem with it.Īsking for my date in excel, sometimes it does with the : sometimes with the. Living just in the english world does not really have those problems.
![how do you insert current date in excel 2013 how do you insert current date in excel 2013](https://media.gcflearnfree.org/ctassets/topics/234/function_library_choose3.png)
So, I am kind of a hardware software language pioneer trying to sort out my crosscultural language minutely changing computer system. So if I do french all day I could adjust to but like this it is a bit nasty. I do some french but that's nasty on that keyboard (you know these accontegraphs and güs and so - that's difficult - especially in google translator, it is always asking the french keyboard.
#HOW DO YOU INSERT CURRENT DATE IN EXCEL 2013 WINDOWS#
Now I am german, english speaking, living in Ukraine and learning ukrainian as 3rd language, that's still some challenge for the windows world. I have but to say I am german, have a Ukrainian Laptop with (most probably russian) Windows set to english, (still always russian comments popping up, so I guess it is a russian windows they sold me) - english set Excel 365 and 3 languages permanently in use on an dual language qwerty english keyboard (especially with imprints for the ukrainian language) and using the Microsoft Keyboard Layout creator for adjusting some keys from russian use to ukrainian. With me sometimes it works just fine but sometimes it does not. So, sometimes, it can be useful to try a mentionned shortcut from the online help in both combinations (Shifted/Unshifted) depending from the keyboard you for the answer. But from an en_US keyboard layouts' perspective, Ctrl+Shift+# is correct. This is due to that # is on a german keyboard reachable without pressing the shift key.
![how do you insert current date in excel 2013 how do you insert current date in excel 2013](https://www.datanumen.com/blogs/wp-content/uploads/2016/12/1-date.jpg)
This does not work, I have to use Ctrl+#.
![how do you insert current date in excel 2013 how do you insert current date in excel 2013](https://cdn.ablebits.com/_img-blog/excel-calendar/excel-date-picker.png)
An example: for applying a date format, the German Online Article mentions that I can use Ctrl+Shift+#. Therefore, the mentionned shortcuts (keystrokes) can lead to confusion and may be appear as incorrect. There is a note about this on the top of the article.
![how do you insert current date in excel 2013 how do you insert current date in excel 2013](https://cdn-7dee.kxcdn.com/wp-content/uploads/2016/11/excel-2013-header-title-every-page-1.jpg)
I already reported this to the MS localization team and they are going to check this.Īnother problem in the online help article for the shortcuts (at least for German) is, that the shortcuts always refer to an English US keyboard. So, in this case, it's for now an error in online help article regarding Ctrl+Semicolon.įor Excel 2016, there are some more errors in the Online Help Article for the German shortcuts, such as some Alt shortcuts, for example Alt+M which opens the Tell Me Box instead of the formulas tab. For inputting the current date in an empty cell, I can use Ctrl+Dot as known from previous versions. I have Excel 2016 in German and I am using a german keyboard.