+ Reply to Thread
Results 1 to 2 of 2

End of financial year from Today() formula

  1. #1
    Registered User
    Join Date
    03-17-2005
    Posts
    7

    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

  2. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,196
    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?

    ---

    Quote 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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1