so I need simple dashboard in sheets , with four entries: starting date, end date, break date, and the fee. lest focus on the element which I know may be the most tricky,
I need to create 5 columns for Monday, Tuesday etc,
next in the column Monday I would like to list all dates of the Monday between start and end day - have this process automated,
next to each date I would like to have tick box (can be any other form of controlling ), one of this tick box would be without the tick, this willl be the date which fallen in the the break week. also I would like to tick off any other date which i may need.
than I would like the amount of the active tick was calculated and summed in the cell below.
the rest of the sheet design would be very simply just calculating total fee according to the fee entry and amount of weeks.
please let me know if you can help
thank you for any support
kind regards Marta