Forum Discussion
Count a particular day in each calendar month
I have over 35 employees and each one has a week day off on a particular day, like, some on Monday, Thursday, Saturday etc. While preparing wages, is their a way how we can use formula to c...
It all depends on how the data is structured.
How to count the number of concrete weekdays between two days is explained here Count day of week between dates . If the month is defined by one date, let say in A1, start date will be EDATE(A1,-1)+1
end date EDATE(A1,0)
AS for the grades - how Excel knows where to take data for such formula? Other words, perhaps it could be helper table with such mapping, and formula returns grade based on this table.
Dear Sir,
Thank you for your response.
Ronald Pinto