Apologies to both Mike and Ossie, as I said this is all new to me and
I clearly haven't explained what I'm trying to do properly :( Let's
see if I can show exactly what I need...
This is the current set up:-

Cell J5
Current - This is the cell that's linked to MS Project, and in this
case shows the % Complete of the task

Cell J6
Qtr 1 - This is where I want to show the % Complete up to and
including 31/3

Cell J7
Qtr 2 - % Complete from 01/04 to 30/06

Cells J8 and J9
Qtrs 3 and 4 - % Complete from the relevant dates

What I want the formula to do is update depending on the current
date. So Cell J6 will update when the user updates the links from 1st
Jan to 31st March, J7 will begin to fill from 1st Apri lto 30th June,
and so on. I need the cells to stay at a fixed figure, within the
quarter, as the figures are being used in charts that graph the
progress by Quarter.

Cell J5 will constantly change, but that's fine as there's another
chart graphing overall progress of the tasks.

The CHOOSE(ROUNDUP) option only works if I'm looking at more than one
column for my results - I think?!?!

Am I going about this the right way? Is it possible to do something
with the link to Project? At the moment, the link in J5 reads:-

{=MSProject.Project.9|'C:\Data\MMMP\Leicester 2009v2.mpp'!'!LINK_11'}

Can I add something to the link using actual dates rather than TODAY
()?

Thanks for your suggestions so far - not your fault I'm hopeless at
explaining things!

Dave