hi everyone..
i was wondering if any of you can help me.
i am making an attendance rollbook for my classes. but i am having trouble with the formula.
what i want is to have excel return the day as a number when i select from a data list the month and the year. i found a from that uses this formula for what i need =DATEVALUE(AC2&" 1, "&AC3)
in that form i choose from a list the month in ac2 and write the year in ac3 but when i try to recreate the same thing in my own form it returns a value error. I have no idea what the 1 in that formula is for. i uploaded the form with the working formula for you to see.
ill appreciate your help..
merry christmas!
Bookmarks