Auto delete date after Anniversary

[shaunB]

Hi All

Is there a formula that will delete a date and inofrmation within a row on the anniversary of that date?

Thanks ShaunB

 

[lenze]

Hi and welcome to the board!!
There is no formula that will delete information, although you can hide it. Something like

=IF(A1<TODAY()+360,"","Whatever")

To actually delete it, you will need code!! If that will work, provide more details about your sheet and what you want.

lenze

 

[lenze]

Sorry, my original formula did not show. It was

=IF(TODAY()>A1+360,"","Whatever")

lenze

 

[shaunB]

Hi
Because I have a total that feeds in I need to alter the row of information so the grand total as it where alters to.
I am building a Bradford factor sheet that formulates amount of sick time an employee takes off. So idealy the complete row of information needs to be taken on Anniversary. This then effects and subtracts th total.

 

[lenze]

You've lost me!! I have no idea what a "Bradford" factor sheet is!!
Please explain with SPECIFICS.
lenze

 

[shaunB]

Sory Lenze,
It is a spesific way of measuring absence at work by a forumula. Its the number of days off sick in a 52 year period x duration of last sick period. number of occurances within the year

Each individual case of absence is subtracted from the over all score on the anniversary.
Does that make it any clearer. It took me ages to grasp the concept.

 

[lenze]

OK!
Tell us what cells(Rows 7 Columns) contain each part of the data and also, how each is entered in the SS. What defines the duration? Do you subtract by days or hours? can you post a sample or upload a n example file to a host such as box.net?

lenze