Скачать или смотреть Data Validation Allow the Entry of Weekdays Only in Excel | Module 5 | Video 87 [Hindi]

Need Job Supoort Click Here - https://topmate.io/bkgulshan11 To allow the entry of weekdays only (Monday to Friday) in a cell or range of cells in Microsoft Excel, you can use data validation and a custom formula. Here's how:

Select the cells or range of cells where you want to allow the entry of weekdays only.
On the Data tab, in the Data Tools group, click the Data Validation button.
In the Data Validation dialog box, select the "Custom" option from the Allow dropdown list under the Settings tab.
In the Formula field, enter a formula to check for weekdays in the cell. For example, to allow the entry of weekdays only in the range A1:A10, enter the following formula: =WEEKDAY(A1,2)=6
Note: Replace "A1:A10" with the cell range you want to check.
Click OK to apply the data validation rule.
This formula will allow only weekdays (Monday to Friday) to be entered into the selected cells. If a user tries to enter a value that is not a weekday, they will see an error message.

🏛️Check Out My Classroom Training Course (Hindi) 🏛️

DAX -
https://learnathome.ongraphy.com/cour...

Excel -
https://learnathome.ongraphy.com/cour...
___________________________________________________________

📞Contact me

  / learnathomewithgulshan  
   / learnathomewithgulshan  
https://learnathome.ongraphy.com/
  / bkgulshan11  

#Excel
#MicrosoftOffice
#MsExcel
#MsOffice
#ExcelOnline
#MicrosoftExcel
#ExcelSheet
#AdvancedExcel
#Microsoft365BusinessBasic
#ExcelSpreadsheet
#Excel2016
#Excel365
#FreeExcel
#DataAnalysisExcel
#LearnExcel
#MicrosoftOfficeExcel
#ExcelWorksheet
#MicrosoftExcel2010
#ExcelForBeginners
#ExcelTricks
#LearnExcelOnline
#AdvanceExcelTopics
#ExcelCourses
#AdvanceExcelSyllabus
#MicrosoftOffice2013
#Excel2013
#OnlineExcelCoursesWithCertificate
#MsOfficeExcel
#MicrosoftExcelCourses
#ExcelCoursesOnline
#FreeMsOffice
#ExcelForDummies
#PowerBiExcel
#MicrosoftExcel2013
#ExcelExpert
#BestExcelCourses
#Tutorial Gear I Used

Monitor https://amzn.to/464xHqi
Mic -1 https://amzn.to/3XcFDSn
Mic -2 https://amzn.to/3X60xCJ
Ring Light https://amzn.to/43BFEBM
Keyboard https://amzn.to/3Jb0Ki3
Mouse https://amzn.to/3p6Uyky
Webcam https://amzn.to/42BRE52
CPU https://amzn.to/3CuPDwR