How to make a dynamic calendar in excel
211.1 هزار بار بازدید -
4 سال پیش
-
1) Use data validation to
1) Use data validation to make drop down lists for the years and months. 2) Use the DATEVALUE and WEEKDAY formulas to make the dates. 3) Use conditional formatting to hide the dates from other months.
=DATEVALUE("1-"&A2&"-"&B2)-WEEKDAY(DATEVALUE("1-"&A2&"-"&B2),3)
---------------------------------------------------------------------------------
#exceltips #exceltutorials #excelformulas
SUBSCRIBE: https://goo.gl/c46YPs
Microsoft Office 365, 2016, Office Insider, Version 2003
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:
- How to make a calendar heatmap in excel of average number of births How to make a calendar heatmap in exc...
- How to make a calendar heatmap in excel How to make a calendar heatmap in excel
=DATEVALUE("1-"&A2&"-"&B2)-WEEKDAY(DATEVALUE("1-"&A2&"-"&B2),3)
---------------------------------------------------------------------------------
#exceltips #exceltutorials #excelformulas
SUBSCRIBE: https://goo.gl/c46YPs
Microsoft Office 365, 2016, Office Insider, Version 2003
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:
- How to make a calendar heatmap in excel of average number of births How to make a calendar heatmap in exc...
- How to make a calendar heatmap in excel How to make a calendar heatmap in excel
4 سال پیش
در تاریخ 1399/02/16 منتشر شده
است.
211,109
بـار بازدید شده