Alright smarter than I folks...I have a production log that I am working and I need help with figuring out how to count only the data that falls in the current month.
I have an Entered Training Date in Column A (A3:A5)
I have a Graduation Date in Column B (B3:B5)
I need a formula to look at those dates and calculate how many days (between Column A and Column B) are in the current month
(October for this example) and provide me the number of days instructed in the current month. (My template is for October 2019)... I have placed an example of what I am looking for in Column X...I would also like to include if possible, Holidays and Weekends (federal government schedule)...
Each month, I have to change data, and if the course Started in September and Ends in November, I will have this on my 3 different trackers
(Sep, Oct and Nov) all of which I need to see how many days were instructed in the current month (Sep, how many days were instructed in, Oct and how many days were instructed in Nov
The tracker is saved by Month...so the File you are viewing would be for October data only...The current process this is being accomplished is copying and pastingand adding and subtracting data manually, which is waisting a LOT of time.
Bookmarks