Forum Discussion
Jsaimz
Oct 06, 2022Copper Contributor
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,...
Jsaimz
Oct 06, 2022Copper Contributor
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
HansVogelaar
Oct 06, 2022MVP
Can you provide one or more examples of what you want?
- JsaimzOct 06, 2022Copper ContributorHi I sent you a private message 🙂