# Auto delete date after Anniversary

#### shaunB

##### New Member
Hi All

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

Thanks ShaunB

### Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Hi and welcome to the board!!
There is no formula that will delete information, although you can hide it. Something like
Code:
``=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

Sorry, my original formula did not show. It was
Code:
``=IF(TODAY()>A1+360,"","Whatever")``
lenze

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.

You've lost me!! I have no idea what a "Bradford" factor sheet is!!
lenze

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.

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

Replies
4
Views
116
Replies
3
Views
112
Replies
4
Views
155
Replies
9
Views
135
Replies
1
Views
137

### Forum statistics

1,196,461
Messages
6,015,381
Members
441,889
Latest member
balolaptopgiaolong

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back