Calendar: Calculate Taken vs Planned time

PTO Calendar.xlsxHello.

If you look at the attachment, you will see that my spreadsheet is a calendar. The goal is for the User to add their "earned time off" in cell D2, then use the calendar portion of the sheet to plan their time off. As they enter hours in the cell dates, I would like the spreadsheet to perform the following functions:[INDENT] Cell D3: Total up those hours that are previous to the date the user is accessing the sheet. (So, if I had an 8 in 05Jan /cell C11/, and I opened the spreadsheet on 06Jan, those 8 hours would be listed as "Taken PTO". [INDENT] Cell D4: Total up those hours that follow the date the user is accessing the sheet: If I opened it today and the 8 hours were listed in cell C11, the "Taken PTO" would hold "0", and "Planned PTO" would indicate 8.

Right now, I'm using "P" to indicated planned hours - and the sheet is counting that as 8 hours. I'm wanting to be able to 'plan' for less than 8 hours if needed. Is there a simple solution for this? I've dug through many of the postings here, and am not finding exactly what I'm looking for, and not excel-saavy enough to figure it out on my own!

Thank you!