Forum Discussion
Formula Help
Hi, I'm trying to write a formula that will help me pull in month to date progress on financials. The data is set up and sent in a weekly forecast format to me. For example 31/01/2022 in cell BI,...
See the attached sample workbook. I used some helper cells. It would be possible to incorporate them into the formulas, but that would make them more complicated.
Hi thank you - that will definitely work to bring in data for the days between weeks which I will use.
How would you go about adapting the formula to add prior dates? For example if it was the 19/10/2022 so you would also have to have the days before as well but only for the month you are in for the month to date view?
Thanks for your help again
How would you go about adapting the formula to add prior dates? For example if it was the 19/10/2022 so you would also have to have the days before as well but only for the month you are in for the month to date view?
Thanks for your help again
Can you provide one or more examples of what you want?
- Hi I sent you a private message 🙂