Dear All,
I'm trying to implement the data validation list in such a way that it should display only dates from first of this month to today
I've created Named range for the below formula which is working fine, but its not working when it is applied to data validation list
So request you to check and clarrify this.
=IFERROR(DATE(YEAR(TODAY()),MONTH(TODAY()),IF(DAY(TODAY())>ROWS(Sheet1!D$1:D1),ROWS(Sheet1!D$1:D1),"")),"")
Bookmarks