Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
ab
 
Posts: n/a
Default Dates older than 29 days

I would like a column in my Excel spreadsheet to be made bold once the dates
in that column are more than 29 days old.
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

Use conditional formatting in say A1:A100 with a formula of =A1<TODAY()-29

--

HTH

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


"ab" wrote in message
...
I would like a column in my Excel spreadsheet to be made bold once the

dates
in that column are more than 29 days old.



  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

One way is to use Format|Conditional formatting.

Cell Value is Less Than =today()-29

(use the dropdowns for the first two and type the last.)

And give it a nice old format.

ab wrote:

I would like a column in my Excel spreadsheet to be made bold once the dates
in that column are more than 29 days old.


--

Dave Peterson
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
Brainteaser about Days Between Dates Johnny Excel Discussion (Misc queries) 5 April 4th 05 05:09 AM
formula to calculate # of days between dates, excluding holidays abs2299 Excel Discussion (Misc queries) 8 March 3rd 05 02:21 AM
Is there a way to calculate business working days between dates i. hjyoungii Excel Worksheet Functions 2 February 23rd 05 04:25 PM
how do I calculate the days between dates? stucklady! Excel Discussion (Misc queries) 7 February 12th 05 04:39 PM
Subracting Dates to come up with the # of days between them KimberlyC Excel Worksheet Functions 8 December 20th 04 09:46 PM


All times are GMT +1. The time now is 09:14 PM.

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

About Us

"It's about Microsoft Excel"