Jan 19 2021 09:26 PM
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.
Jan 19 2021 11:14 PM - edited Jan 19 2021 11:15 PM
@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
Jan 20 2021 12:49 AM
will give a shot ,thank you so much for your kind assistance @Riny_van_Eekelen
Jan 20 2021 12:58 AM
Jan 20 2021 01:48 AM
@agusgusto You're welcome!