Get instant live expert help on I need help with week formula in excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
how to do continuous recursive formula. Starts with n=0 being week one starting with 1 second. Continues to week 35. Every week the seconds double. Need to put in first formula and excel does the rest.
Solved by X. W. in 25 mins
I have created an Excel Dashboard that I am wanting to read out from another excel page two columns "Last Week" and "Current Week" information. What is the best formula to use?
Solved by X. F. in 18 mins
In my formula I refer to a tab with the name of a week. I want to automatically change this formula into a new week (this is stated in cell Q1). How do I do that?
=ALS($P$1='Week 38'!$D$3;VERT.ZOEKEN($B5;'Week 38'!$D$5:$E$153;2;ONWAAR)
Solved by V. F. in 30 mins
I have a weekly activity excel workbook with sheet 1 named "Week 1".
The "Week 1" worksheet has formulas referring to other sheets in the book.
I want to run a macro that:
- creates a new sheet and names it "Week 2"
- copies the formulas from "Week 1" to "Week 2"
- Sets the Data in "Week1" as absolute (copy and past as values)
- Selects cell C3 in Week 2
Solved by T. H. in 17 mins
I need an Excel formula that will return a week day if the results is a weekend.
Solved by M. A. in 12 mins