Business Week

[crofsx]

Hello,

I have a spreadsheet (attached) containing 3 columns, week commencing (c), week ending (d) and business week (e). The question is can a user enter a date in one cell (b4) and have the next cell (b5) return the corresponding business week, I have come up with a couple of solutions involving hidden columns but was wondering if there is a way to do all of this in one cell.

Thanks

[shg]

The Monday on or before the date in A1 is =A1-WEEKDAY(A1, 3)

[crofsx]

Thats a big help, thanks.

[shg]

You’re welcome. Would you please mark the thread as Solved?

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes