Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
diving1
 
Posts: n/a
Default How do I change content of a cell based on date

I want to delete certain cell contents based on a future date
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

Do you mean delete cells with this future date, or deletes certain cells if
an associated cell has the date.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"diving1" wrote in message
...
I want to delete certain cell contents based on a future date



  #3   Report Post  
Tom Ogilvy
 
Posts: n/a
Default

Onepossibility:

Look at Data=filter=Autofilter

filter on the date

Select the data (not the headers) and do Edit=Delete

Only the visible rows should be deleted.

--
Regards,
Tom Ogilvy

"diving1" wrote in message
...
I want to delete certain cell contents based on a future date



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change the value in cell based on a future date John W Excel Discussion (Misc queries) 2 December 21st 04 01:27 AM
Addition to Turn cell red if today is greater or equal to date in cell Rich New Users to Excel 2 December 9th 04 02:06 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM
How to change (delivery) days and automatically the receive date in an other cell? Elboo Excel Worksheet Functions 5 November 22nd 04 02:44 PM
Using formulas to determine date in one cell based on date in anot Gary Excel Worksheet Functions 2 November 22nd 04 08:11 AM


All times are GMT +1. The time now is 05:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"