Forum Discussion
Solved
Return value if the day of the month is between 2 dates
Hello, I have a cash flow summary (calculates out 4 to 6 weeks) and I need it to automatically enter values based on the day of the month and a week ending date. For example: - we need to p...
Would this work?
=(DAY(D$1)=MEDIAN(DAY(D$1),20,25))*20000Small example attached, but changed it to make it dynamic, where the amount, the minimum and maximum day values are replaced by cell references.
Would this work?
=(DAY(D$1)=MEDIAN(DAY(D$1),20,25))*20000
Small example attached, but changed it to make it dynamic, where the amount, the minimum and maximum day values are replaced by cell references.
Riny_van_Eekelen Sorry for the delay in replying. Thank you so much! It worked for what I was trying to do.