0
votes
0answers
5 views

How do I calculate the first Monday of next year in Excel? [migrated]

I need a formula to calculate the first Monday next year (or first Tues, Weds, Thurs, etc.) based on the date in cell A1. So for instance, if the date in cell A1 happens to fall on a Thursday, ...
0
votes
0answers
211 views

Hiding Formulas on Excel Spreadsheet and Google Docs

I've created some formulas in my Excel Spreadsheet. I've locked and hidden them so that employees don't accidentally mess up the formulas by clicking on them. However, when I send the file thru email, ...
1
vote
1answer
3k views

Is there a way to search and replace a regular expression in Google Docs spreadsheets?

The problem is that I entered a lot of formulas like =round(x+y) into a Google Docs spreadsheet. Now I need them exported to MS Excel and the latter only accepts =round(x+y,0) as a valid format. ...