When is the next Monday? [Homework]
Psst. Hey you, yeah, you there… have time for a quick date? A date with Excel that is.
If so, take up this homework problem and post your answers in comments.
Assuming you have an input date in cell A1,
- What is the formula for finding next Monday?
- What is the formula for finding first Monday of next month?
Note: If input date is a Monday, you need to calculate the next one.
Post your answers in comments
Need a clue? Check out Excel Date & Time concepts.
Want additional challenge?
Try to solve the problem using either Power Pivot or Power Query. In both cases, assume your input is called [input date] or #”input date”
Go ahead and post your answers. Your date is waiting…
Craving for more? Other Excel homework problems for you.
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Performing Maths in Microsoft Word (In an Excel Blog)||5 tips: Power Query for Accountants (and finance people) – Free Masterclass »|