Need help for formula

[PrashanthShastry]

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

[#2]

@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.

[#3 · Accepted solution]

Done Its fine, Thanks a lot, Thank you Sir.