Calculating which day from date?

  • Thread starter Thread starter roandr
  • Start date Start date
You'll need to make those references to the pay rates absolute if
you're intending to copy down.
Click to expand...

Thats already been done. On the 4th or 5th edit of my post ;)
I'd break up the formula into separate cells (perhaps in hidden
columns); it will make understanding and editing easier in future.
Click to expand...

Yes, I found myself forced to do this. I had no chance of understanding
it all in once. I have a workbook with this divided into parts.
Also I think a VBA function might be a better solution.
Click to expand...

I wouldnt know. Could you please elaborate and maybe paste a couple of
links?
 
Hi roandr!

Can you provide a complete schedule with the rates and periods they
apply to? That should make it easier.

The UDF won't be easier than your formula but it will be easier to
reproduce elsewhere.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top