Here’s how to set up a formula with WEEKNUM: 1. Enter 10 or 12 random dates in cells A4 to A15. 2. Move your cursor to B4. Go to Formulas > Date & Time and select WEEKNUM from the dropdown list.

Do you use Excel spreadsheets to keep track of your weekly, monthly or annual expenses but find yourself updating all relevant date and content information manually? There is an easier, more effective ...

We delve into the Excel Date & Time functions EDATE, YEARFRAC, EOMONTH, and NETWORKDAYS.INT. All are handy for going back and forth in time on retirement dates, expiration dates and more.

So, if it’s 2018, you can enter only 2018 dates. If it’s 2019, you can enter only 2019 dates. You don’t need to update the formula or the control as time passes.