End of financial year from Today() formula

Hi,
I am trying to create a formula that automatically calculates the end of the financial year (30/6/2007) from the value in the today() cell, i've tried using IF statements but with no success, any help is appreciated!!

Dwayne

Not sure how you mean to 'calculate the end', did you mean detect if today was that date?

=IF(TODAY()=A1,"yes","no")

where A1 contains a date will reply 'yes' when that date is today.
Does this help?

---

Originally Posted by dwayneh

Hi,
I am trying to create a formula that automatically calculates the end of the financial year (30/6/2007) from the value in the today() cell, i've tried using IF statements but with no success, any help is appreciated!!

Dwayne