Forum Discussion
Auto Divide Cell Value to Specified Cells in a Column
Let's say you also want to exclude Meeting.
Change COUNTIF($D$5:$D$9,"Absent") to (COUNTIF($D$5:$D$9,"Absent")+COUNTIF($D$5:$D$9,"Meeting"))
and COUNTIF($D$5:$D$9,"<>Absent") to
COUNTIFS($D$5:$D$9,"<>Absent",$D$5:$D$9,"<>Meeting")
You can add other options the same way.
Hello, Hans. I got another newbie roadblock. I'd like to set up a workbook in such a way that when I select a month from a dropdown in cell x, the dates along with the values I keyed in every day of those months will autopopulate accordingly. How can I go about doing that? Thank you so much in advance.
 
In B3:
=DATEVALUE(("1-"&A2&YEAR(TODAY())))
In C3:
=IF(B3<EOMONTH($B$3,0),B3+1,"")
Fill to the right to AF3.
Apply the custom number format mmm-dd to B3:AF3.
Thank you, Hans. What if I have a data list of all months of the year in A2, and I want to see the records I have in August so I select August right. But I also would like to view September records automatically when I select the September from A2 dropdown. Im not sure if that's a macro. But how can I make it function like that? Im not sure if Im being clear. Haha. I wish I am. Thank you again!
My previous reply will automatically fill the days of the month you enter in A2. So if you enter August, it will enter Aug-01 to Aug-31. If you enter September, it will enter Sep-01 to Sep-30.
It doesn't fill any "records" since I don't know how that would work.
