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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks