The most difficult portion, I think, is that Access doesn't have functions such as Weekday, so calculating a date based on a date + [days until Friday] would require more effort. If the date is an actual date then it's easier. You should be able to create a working, stable db if you do some up front research and thorough planning. The worst thing would be to design using your Excel brain. How are you with knowledge about basic relational database design principles?
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.