SOLVED

Need help for formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2865359%22%20slang%3D%22en-US%22%3ENeed%20help%20for%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2865359%22%20slang%3D%22en-US%22%3E%3CP%3EFriend%2C%20Windows%2010%20OS%20%26amp%3B%20Office%20Home%202016%20version%2C%20I%20am%20using%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20Change%20(A7)%20Cell%20formula%20must%20change%20everday%2C%20just%20like%20%22countif%20value%20need%20to%20change%20next%20column.%20for%20example%20Today%20A1%3A%20A5%2C%20tomorrow%20B1%3AB5%2C%20day%20after%20tomorrow%20C1%3AC5%22%3C%2FP%3E%3CP%3EPlease%20do%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Excel%20Sample%20File-Snap%20Shot.jpg%22%20style%3D%22width%3A%20637px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F318712iD9CAED94E6EB87FF%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Excel%20Sample%20File-Snap%20Shot.jpg%22%20alt%3D%22Excel%20Sample%20File-Snap%20Shot.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EPrashanth%20Shastry%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2865359%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2865560%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20for%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2865560%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1183258%22%20target%3D%22_blank%22%3E%40PrashanthShastry%3C%2FA%3E%26nbsp%3B%20%26nbsp%3BThere%20are%20a%20few%20ways%20to%20do%20this.%26nbsp%3B%20Here%20is%201%20option%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DCOUNTIF(INDEX(%24A1%3A%24AE5%2C%2CDAY(TODAY()))%2C%22YES%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3Ewhere%20the%20formula%20will%20pick%20the%20column%20based%20on%20which%20day%20of%20the%20month%20it%20is%20today.%3C%2FP%3E%3CP%3Ealternatively%20you%20could%20have%20other%20ways%20to%20pick%20the%20column%20including%20using%20MATCH()%20if%20needed.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2868101%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20for%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2868101%22%20slang%3D%22en-US%22%3EDone%20Its%20fine%2C%20Thanks%20a%20lot%2C%20Thank%20you%20Sir.%3C%2FLINGO-BODY%3E
New Contributor

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 

Excel Sample File-Snap Shot.jpg

Prashanth Shastry

2 Replies

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

best response confirmed by PrashanthShastry (New Contributor)
Solution
Done Its fine, Thanks a lot, Thank you Sir.