Forum Discussion
Solved
Days worked in Month - PQ/M functions possibly
Hi Folks, I am trying to automate a spreadsheet that seems like it should be easy, but there's a hurdle that's tricking me. I don't mind if I have a solution that uses regular excel formulas,...
davidmaddock54 As a variant, using the example kindly provided by tauqeeracma , try this:
=MIN($G$1,C2)-MAX(EDATE($G$1,-1)+1,B2)+1
Ideally, your variant should be used as it is more simple and straightforward.
Nice one.
Thanks
Tauqeer
Thank you. Certainly, my formulas were reaching that sort of length, but they weren't working!