Get instant live expert help on how many weekdays in a year
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I have the formula =text(weekday(date(calendaryear,1,2),1),”aaa”)
Automatically updates the weekdays in the row according to the year entered in a different cell.
But I also want to automatically update the weekdays in that same row according to the month entered in a different cell(b4). How should I change it my current formula
Solved by O. F. in 18 mins
how many sales do I need to make 30,000 a year
Solved by M. E. in 12 mins
I need to identify how many positions were added in 2017-2018 in comparison to the previous year and identify how many positions, what type of positions and the financial impact.
Solved by X. U. in 19 mins
The data to the left should be all weekdays (Monday-Friday), but days are missing.
Definition: An "integrity check" is a true/false cell the shows if there's a problem with the data.
1. Create an integrity check that returns FALSE if there are any missing weekdays. Feel free to use Columns F, G, H, etc. if you need a workarea in creating this master integrity check.
<---- Integrity check formula:
<----How many missing dates
List the missing dates:
Solved by A. B. in 11 mins
how do i find the frequency of how many times each customer bought something within the year
Solved by S. J. in 24 mins