year function and financial years
Look under toolsoptionstransition if you have transition formula
evaluation checked, of so uncheck it, only other option would be a date
earlier than Apr 1900 or an empty cell
--
Regards,
Peo Sjoblom
"Martin_London" wrote in message
...
Thanks JE
My formula now reads
=IF(AND(D$3=SPVs!$F$12,YEAR(DATE(YEAR(D$3),MONTH( D$3)-3,1))=YEAR(DATE(YEAR
(-SPVs!$F$12),MONTH(-SPVs!$F$12)-3,1))),$O82/(15-MONTH(SPVs!$F$12)),IF(AND(D
$3=SPVs!$F$12,YEAR(DATE(YEAR(D$3),MONTH(D$3)-3,1))=YEAR(DATE(YEAR(-SPVs!$F
$12),MONTH(-SPVs!$F$12)-3,1))),$O82/12,0))
with D$3 and SPVs!$F$12 being two dates but I am getting a #NUM! error.
Any ideas?
Martin
"JE McGimpsey" wrote:
one way:
instead of
=YEAR(A1)
use
=YEAR(DATE(YEAR(A1),MONTH(A1)-3,1))
In article ,
"Martin_London" wrote:
In the UK our financial year runs April to March. Is there any way of
using
the =year() function on a date so that it runs on these dates rather
than
calender years? Basically I need Jan, Feb and March of next year to be
recognised as the same year as April to December of this year.
|