-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
months calculations
-
Looping through A3-A13 with monthly numbers (Formulas only)
Hey all Excel warriors, I'm currently designing a totally new workbook at work which involves every single item within our warehouse, combined with a forecast of the monthly marketing. I got an idea at work today and started working on a concept that I found logical and might actually work 🤔 Now...- deadlyjack
- Thread
- formulas loop a formula months calculations
- Replies: 6
- Forum: Excel Questions
-
S
Months to quarters
A sales database processes reports that can both we monthly or quarterly. For the quarterly ones the data can be presented in the following format: "Jan-18,Feb-18,Mar-18" Is there a formula that could recognise such a string and product a result (in this example): "Q1-18" Thank you.- simonstone
- Thread
- formula months calculations quarterly quarters recognise
- Replies: 2
- Forum: Excel Questions
-
C
Formula: formula that bases total on current month throughout the year
Not sure how to phrase this - can I create a single-cell formula that knows what month it is and adjusts accordingly? Over a two-year period, the project team needs to hold a total of 52 meetings (with guidance to have 2 meetings each month with an additional 4 whenever). My spreadsheet lists...- Churchy LaFemme
- Thread
- additional formula meetings month months calculations
- Replies: 8
- Forum: Excel Questions
