057 Using Spin Buttons and date choose weakday to desginTemplates Holidays part4
2 تحميل كتاب الإكسل للمهندسين pdf
3 كتاب مجاني شرح أكثر من 100 دالة من الإكسل
4 كتاب متقدم جدا 👌 كتاب طرق الاهلاك باستخدام دوال الاكسيل
المعادلة الذهبية للتاريخ والوقت في Excel هي: يمكن معرفة تاريخ اى يوم فى اى سنة بمجرد وصفه مثلا --------------------------- Year 2154 ------------------------------------- When Date ---------------------------------------------------------------------------- January 1 Tuesday, January 01, 2154 The 3rd Monday in January Monday, January 21, 2154 The 3rd Monday in February Monday, February 18, 2154 The last Monday in May Monday, May 27, 2154 July 4 Thursday, July 04, 2154 The 1st Monday in September Monday, September 02, 2154 The 3rd Monday in October Monday, October 14, 2154 November 11 Monday, November 11, 2154 The 4th Thursday in November Thursday, November 28, 2154 December 25 Wednesday, December 25, 2154 The 2nd Wednesday in October Wednesday, October 09, 2154 ===================================================================
كيف احسب تاريخ يوم الاثنين رقم 3 من شهر يناير سنة 2023
=DATE(C2,1,1)+14+CHOOSE(WEEKDAY(DATE(C2,1,1)),1,2,3,4,5,6,0)
= DATE(C2,1,1)+13+CHOOSE(WEEKDAY(DATE(C2,1,1)),2,1,7,6,5,4,3)
= DATE(C2,1,1)+13+WEEKDAY(DATE(C2,1,1))
The 4th Thursday in November
11 =DATE(C2,11,1)+28+CHOOSE(WEEKDAY(DATE(C2,11,1)),1,0,6,5,4,3,2)
DATE()
CHOOSE( )
WEEKDAY( )
in excel
the steps on how to use Spin Buttons, date, and weekday functions in Excel:
Create a new Excel spreadsheet.
In cell A1, enter the date of the holiday.
In cell B1, insert a Spin Button control.
In the Spin Button control's Properties dialog box, set the following properties:
Minimum value: 1
Maximum value: 31
Value: 1
In cell C1, enter the following formula:
=WEEKDAY(A1,2)
This formula will return the weekday of the date in cell A1, using the 2-digit format.
6. Format cell C1 as a text cell.
Now, you can use the Spin Button control to change the date of the holiday. The weekday in cell C1 will automatically update to reflect the new date.
To design Templates Holidays based on the weekday, you can use the formula in cell C1 to create a conditional formatting rule. For example, you could create a rule that formats cell A1 as red if the weekday is a Saturday or Sunday.
Here is an example of how the spreadsheet would look:
Date | Weekday
------- | --------
2023-08-21 | Monday
To add a Spin Button control to your spreadsheet, follow these steps:
Click the Insert tab.
In the Controls group, click Spin Button.
Click the cell where you want to insert the Spin Button control.
Drag the control to the desired size.
In the Spin Button control's Properties dialog box, set the properties as needed.
The WEEKDAY function in Excel returns the weekday of a date, based on a 1-based Sunday. The 2-digit format returns the weekday as a number from 1 to 7.