Was wondering if i could get some help please.
If i had the numbers 1(start) - 30(end), the numbers in between i want are 10 & 20. How do i do that with dates?
Cell A1 has the start date 1/1/2022
Cell A2 is empty
Cell A3 is empty
Cell A4 has the end date 14/3/2022
What would the formula be to find the dates to fill cells A2 & A3?
I know in cell A2 i can do =AVERAGE(A1,A4) & that will give me the middle date between start date & end date. But i would like to fill both empty cells. In 1/4's i guess?
Any help much appreciated.