Hi everyone , any change you can help me with a formula , trying to get the excell to auto fill the cells when i change the date or numbers (file attached )
Looking for a formula that will auto-fill the cell in multiple columns (same row ) if they are within the date range .
So looking if date range from C6 and D6 are within the dates from J3 to CI3 to divide E6 in equal numbers in all the cells from same row and columns that are included in date range .
sorry if a bit confusing but english isn't my 1st language , i did fill them in manualy (j6-N6) .
Bookmarks