Calculation when starting mid-month

Originally Posted by vba_php

in cell c7 there is the value of january 1900,

January 1900 is entered just o there is a default month to fill in the months for Column C

Originally Posted by vba_php

cell b87 on sheet month 1 is labelled as ""activity"". so you are wanting a date on the first sheet to equal a value for "activity" on the 2nd tab

I have/will upload another version of the spreadsheet with data entered as a Learner would see it. The "Activities" on Sheet "Month 1" are there (B82:B86) for Data Validation to make a drop-down list, and also to be used to calculate the Pie Chart (in case management want to change the name of each activity)


They might not make much sense as the Original version has 18 x "Month" Worksheets, so that all of the Front Page self-completes.

As you can see from my version, I have started on 20/08/20, and so I should only be needing 30% of the Monthly Hours, but because it works on 100% of the whole month it is still expecting me to give 30 hours training, not just 10.