Clear contents based on date

deemer98

Board Regular
Joined
Sep 9, 2005
Messages
128
Good afternoon all. Is there a way to set a formula or conditional format that will clear the contents of a cell after so many days?

Cell D1 contains a date. After365 days, I want that cell to clear the date out. Is that possible?

Thanks!
 
Ok, the TEST ran perfectly and showed me the message. I went back to my original file and put all the info form #12 in just like It did for the TEST, and went to View Macros.....nothing there :(
 
Upvote 0

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
I really have no other ideas without being able to actually see the file.
Are you able to upload it to a file sharing site (like "Dropbox") and include a link to it here?
 
Upvote 0
I really have no other ideas without being able to actually see the file.
Are you able to upload it to a file sharing site (like "Dropbox") and include a link to it here?


I'm not sure. I've never used dropbox but I can try. I will need to do that from my home computer though.
 
Upvote 0
I just noticed that after I click on THisWorkbook, then when I click in the box to paste the code, it changes back to Sheet1(Attendance)
 
Upvote 0
Try double-clicking on "ThisWorkbook" to get into the edit box of that module.

Note you can use any file sharing site you like (like Google Drive, Dropbox, etc).
 
Upvote 0
BINGO!!!!!! That's what was happening. It wasn't pasting in ThisWorksheet! WOW! I appreciate all the help! Thank you so much!!!!
 
Upvote 0
You are welcome.

Glad we were able to figure it out.
 
Upvote 0

Forum statistics

Threads
1,213,506
Messages
6,114,025
Members
448,543
Latest member
MartinLarkin

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top