Dynamischen Kalender erstellen + Download (Excel)Jun 30, 2022
double and now I pack everything into a valve function which means I write if there is an error outside or attach the event function so to speak the first parameter is our formula so to speak because if an error is expected , just two different parameters once our formula so to speak and according to the formula what should happen if an error occurs where there was value in it then there should be nothing at all that means we go again here two quotes, a square bracket and I press wrong and here our form is also executed as it should be now I
downloadit again and then we can look at the same thing again I do it until 37 or until 40 and you see 31 skin there is nothing anymore here so we can also leave the strikers you saw and you see what you see yes and you can do that from a page so copy this formula down or just the whole file this is how the formula should look like what we need to look at now , Yeah However, I had seen that now I lowered that at the beginning and now I lowered it beyond 31 and you have to pay attention if, for example, you still have a formula here and you can see it here as well if I now double click on it then the formula is in it throws all the formulas that could be after the 31st so it takes the furthest possible entry within a calendar year much of the 31st and then throws everything back in because if we're going to print after that I might have the problem that the horizontal and vertical centering changes accordingly because there's actually still a bit of the content somewhere here means I just click on it when I like these cells here right click again and delete the cells you've seen they refer to to the right cell so to speak it's relative so we can copy this cell completely down here using the controller totally easy and even though I do it everywhere but 31 it's ada pta to super simple so to speak now you can Then we copy everything and I'll make it a little smaller so we can still see December.
I hope you see it's not that easy and except for the first line I do it from line 5 onwards these two column areas as said. apart from the first line where sunday is the first shift and now you can cover that completely here i pull this here like i said completely to the point where the first twelfth is constantly coming loose and everywhere it fits you can also see here For example , nothing is entered anywhere. February, for example, only has 28 days, and therefore there is no content on the 29th, 30th, and 31st. These areas are also missing here because the month is not that long and if I enter 2016 here, for example, I just go let's do 2016 so pay attention to this here's another day because 2016 for example has 29 days they adjusted every day of the week etc so that's great i want to do it now even if you can't see it that well now but mark the whole table again first the whole table we'll do it with this little symbol everything is marked and i want everything to be centered look that's it now more or less justified to the right actually doesn't look that good i think i did i want centered i just click all it is now season centered if you left justify afterwards or do it now straight and it will probably format two cells the same as i do now however i still want all weekends to be marked in color, so to speak, that means It shows that I like animals here again completely the entire area completely and then go here to conditional formatting select me here new rule velemir use the input formula below to determine the cells to be formatted now you can enter a function here and I'll take it here r the day of week function the day of week function takes the day of the week out of a date so to speak and returns values to me and i'll explain that very briefly first of all i'll open a day of week bracket and you I'll see if you've marked it like this, you're still using it white label here inside the area and it's very important that it's here too so if I need it to be different open the area again it's important that the white label is definitely young, so these targets that we're now inputting here so to speak is this white cell so a4 because it says our date so to speak we just output the day of the week here but there's all via there is a complete date in it and we want to have the day of the week from this date and as a return value I would like to set it like this monday is a single tuesday is a 2 wednesday is a 3 and so on and i put that with number 2 yes because another eg. ahl clean or put another number for clean then it may be that Sunday is one and consequently you really have to use a 2 1 here so that Monday 1 1 is Tuesday the 12th and consequently Saturday is the 16th and Sunday the 17th and that's exactly what we are using now we want to know if the day of the week is greater than 5 ie 6 and 7 ie saturday and sunday ie all five are still entered then the following should happen ie if it is saturday and Sunday, then the background should be gray, for example, about a different format, I click on format, of course, I can set a lot more, but I go here to fill in velemir here this gray mouse, click ok and click in ok and then you will see that all my weekdays are light and only weekends are together now and even if i change the date now and i will do it in 2010 i will take it as an example and press change then you will see r automatically adapt what still we can do now for example here yeah i'll keep it as small as possible so you can really mark everything here on line 3 for example i click up then it's marked here all the time and i want you like to have fed that names of the month are fat s my tears are a little bit bigger and that's what i do here with this pick i'll take some take the feature is pretty good i think it was o 15 15 is great too but it's better that way and that's clear here , the year numbers need to be really big and I'm going to make them really big which means I'm going to take 28 here which still makes two cells here which means I like to connect and center these two g's in the cells and still align it to the left a little bold and that doesn't look bad at all that 2010 is of course a bit stupid because no one in 2017 and as I said it fits very well I'll be now I'll show you very briefly how it works with printing however, I'd like to do something quick here and you can see the columns are too wide and consequently I'm now marking each column with the young column designation like tell it all and pay attention if we change anything now it will change in all columns by same, so e pay attention to sept for example you have to take a look there because if it's too narrow then of course it looks a bit stupid but i think that might fit we can make it a bit bigger now that actually it doesn't look too bad at all plus you shouldn't make so many mistakes here now ok let's go to the print area that means I go to archive then go to print and you can see we still have the portrait format right now if we want to have it in landscape format, for example, we can specify that here.
As you can see here, you can set that. I go for the landscape format but we only have it here from January to September and if we now want to have everything on one page then we can select the sheet on a page down here in the bottom area where there is no representation of scale if now I'm here on the clique, then you can see how everything is put on one page so that overall it looks kind of cool. I'll come back very briefly and we'll just increase the columns or what I said the line goes up a little bit then you can see it just cool down I'm going to come back again just mark the whole area here bang and just put it down a little bit but pay attention I know this of course can be very big on each line and I went back then and if we look at it again now print the file then everything looks like this I think everything with the format like this then you can figure it out yourself and if you want to have a grid line etc for example but i just wanted to show you that now you have a dynamic calendar you just need to change the year and the calendar will adjust automatically and i really dont think that is very good and i would be happy if you like it if you leave a thumbs up and if i see you again in other tutorials all is well until then j
If you have any copyright issue, please Contact