Oct 20 2021 07:06 AM
Friend, Windows 10 OS & Office Home 2016 version, I am using,
I need to Change (A7) Cell formula must change everday, just like "countif value need to change next column. for example Today A1: A5, tomorrow B1:B5, day after tomorrow C1:C5"
Please do
Prashanth Shastry
Oct 20 2021 07:46 AM
@PrashanthShastry There are a few ways to do this. Here is 1 option:
=COUNTIF(INDEX($A1:$AE5,,DAY(TODAY())),"YES")
where the formula will pick the column based on which day of the month it is today.
alternatively you could have other ways to pick the column including using MATCH() if needed.
Oct 20 2021 11:28 PM
SolutionOct 20 2021 11:28 PM
Solution