💻 Software
What Excel formula can I use to calculate the 2nd Monday of a given month?
Fresh5 days ago
Mar 15, 202673232 viewsConfidence Score0%
0%
Problem
What Excel formula can I use to calculate the second Monday of a given month? You can assume I have a cell containing the first day of the month to work with. In the interests of other users, can you please also explain how to alter the formula to get the 1st, 3rd or 4th Monday of the month too, an…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: What Excel formula can I use to calculate the 2nd Monday of a given month?
Low Risk
Here's something I found with a quick search: Generically you can get the nth xday of the month with this formula where year is in B2 and month (as a number 1 to 12) is in A2, and where xday is a number representing the day of the week (1 = Sun thro…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix