Hi - I;ve had a look through and cant find a solution to this problem.

I have a column that returns a Quarter (of financial year) dependent on the
date of an invoice. So an invoice date of 13/04/2009 returns Q1 in the
column. I am doing this by converting the date by =datevalue(), and a nested
IF formula based on those values. It works great for the dates that I have
already, but if I add a row, or change a date (for instance July's rent was
invoiced 30/06/2009, but I need to change that date to 01/07/2009, or even
30/07/2009 to make July's rent fall into Q2) it returns #Value! instead of
the number. I have checked everything I can think of to do with the format,
but I cant come up with a reason. I am using 2007 on XP.

Thanks for any help.

--
Thanks
Michele