Oct 06 2022 03:58 AM
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, then 07/02/2022 in BJ and so on; with the corresponding values below the dates for different lines for sales, profit etc.
Does anyone know what formula would work that would automatically update based on today date? For example if the date fell between week commencing 07/02/2022 and week commencing 14/02/2022 such as 10/02/2022 it would need to divide 4 days of the value of that week.
Thanks
Oct 06 2022 04:22 AM
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.
Oct 06 2022 04:54 AM
Oct 06 2022 04:56 AM
Can you provide one or more examples of what you want?