Hi,
I am trying to work on a overtime record whereby the overtime hours render on report the based on the month selected. However, my index sumproduct formula doesnt seen to execute as expected as my data were recorded in datetime format instead date. How to get the data in date instead datetime
Formula:
Please Login or Register to view this content.
Your assistance is greatly appreciated. Attached is my workbook on the overtime record
Thanks and Best Regards,
Kenneth
Bookmarks