If statement - Need to stop the today's date calculation

Hello All , new to the forum but I am so glad I found it. Hoping someone can chime in and help me out with an issue im having.

This formula is being used in a vacation time spreadsheet. So after each paycheck the if statement is applied and need to calculate the accumulation for that week based on if the person has worked 5 yrs or less. I need to stop the today's date calculation in the if statement after it is used. So that each time the spreadsheet is opened the values are a fixed number not changed based on the current date. However if the if statement is pasted into the next pay week it will calculate based on the actual date.

It is calculating is the following:

C4 = 5yrs Anniversary Date of Hire
3.08= less than 5 yrs
4.62= more than 5 yrs

=IF(($C$4)<=TODAY(),4.62,3.08)


Please let me know if you need more information to help out.

http://i1253.photobucket.com/albums/...r/Capture2.gif

http://i1253.photobucket.com/albums/...r/Capture1.gif

Hi and welcome to the forum

1st, Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you Also, not all members can upload picture files (Company firewalls and stuff)

2nd. If you are using =TODAY(), there is no regular way to "stop" it (you could set calcs to manual, but it will recalc on F9) Maybe what you need to do is not use TODAY() exactly, but rather reference it in a forrmula so that it gets tested for if the date is within "x" days

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic