Forum Discussion
aaronrey
Aug 27, 2019Copper Contributor
Formula for automatically setting a 'start date & end date'?
I am wondering if there is a formula I can use to automatically calculate the start date and end date of a job based on the first and last time recorded spent on it (please see screenshot). I am ...
SergeiBaklan
Aug 27, 2019Diamond Contributor
Please check this https://techcommunity.microsoft.com/t5/Excel/Reverse-HLookup/m-p/821490 thread, looks similar