Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
datevalue returns #value
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index with mulitple value returns and muliple column returns | Excel Worksheet Functions | |||
Help With DATEVALUE | Excel Worksheet Functions | |||
Something other than DATEVALUE | Excel Worksheet Functions | |||
datevalue() | Excel Worksheet Functions | |||
datevalue | Excel Worksheet Functions |