only range date of month allowed to be entered in cell

%3CLINGO-SUB%20id%3D%22lingo-sub-2077475%22%20slang%3D%22en-US%22%3Eonly%20range%20date%20of%20month%20allowed%20to%20be%20entered%20in%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2077475%22%20slang%3D%22en-US%22%3E%3CP%3Ehello%20anyone%2C%20i%20am%20currently%20work%20on%20a%20sheet%20that%20contain%20formula%20%3D(%20cell%20number%20%2B1)%20in%20one%20of%20the%20column%20so%20if%20first%20row%20contain%201%2F1%2F2021%2Cthe%20next%20rows%20will%20be%20filled%20with%20range%20of%20dates%20in%20specific%20month.%3C%2FP%3E%3CP%3Ethe%20issue%20is%20not%20all%20month%20contain%2031%20days%2Ctherefor%20i%20would%20like%20to%20put%20restriction%20if%20the%20cell%20contain%20date%20that%20exceed%20the%20number%20of%20date%20in%20that%20particular%20month%2Cit%20will%20show%20blank%3C%2FP%3E%3CP%3Eas%20i%20will%20work%20on%20all%20months%26nbsp%3B%20i%20would%20like%20it%20to%20be%20formulated%20instead%20of%20erase%20manually%20data%20if%20it%20exceed%20value%20of%20date%20in%20that%20month.your%20help%20is%20highly%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2077475%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2077723%22%20slang%3D%22en-US%22%3ERe%3A%20only%20range%20date%20of%20month%20allowed%20to%20be%20entered%20in%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2077723%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F932666%22%20target%3D%22_blank%22%3E%40agusgusto%3C%2FA%3E%26nbsp%3BPerhaps%20you%20can%20use%20any%20of%20the%20solutions%20provided%20in%20the%20attached%20workbook.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20uses%20the%20SEQUENCE%20(dynamic%20array)%20function%2C%20only%20available%20in%20newest%20Excel%20versions.%20The%20other%20uses%20functions%20that%20are%20available%20in%20all%20Excel%20versions.%26nbsp%3BEnter%20the%20first%20day%20of%20the%20month%20on%20the%20yellow%20cell%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2077911%22%20slang%3D%22en-US%22%3ERe%3A%20only%20range%20date%20of%20month%20allowed%20to%20be%20entered%20in%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2077911%22%20slang%3D%22en-US%22%3E%3CP%3Ewill%20give%20a%20shot%20%2Cthank%20you%20so%20much%20for%20your%20kind%20assistance%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

hello anyone, i am currently work on a sheet that contain formula =( cell number +1) in one of the column so if first row contain 1/1/2021,the next rows will be filled with range of dates in specific month.

the issue is not all month contain 31 days,therefor i would like to put restriction if the cell contain date that exceed the number of date in that particular month,it will show blank

as i will work on all months  i would like it to be formulated instead of erase manually data if it exceed value of date in that month.your help is highly appreciated.

 

 

4 Replies

@agusgusto Perhaps you can use any of the solutions provided in the attached workbook.

 

One uses the SEQUENCE (dynamic array) function, only available in newest Excel versions. The other uses functions that are available in all Excel versions. Enter the first day of the month on the yellow cell

will give a shot ,thank you so much for your kind assistance @Riny_van_Eekelen 

work perfectly riny,thanks a million !!!!!!