LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Formula to show a date in red if /= 365 days old in Excel?

I keep a log of dates that people receive financial assistance which is in
effect for 365 days. After 365 days they must renew their application.
Currently, I manually look for dates that are 365 days old and change the
text to red. I would like to find a formula that would do this for me.
 
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
Excel Formula to calulate number of days passed from date to date K. Mack Excel Discussion (Misc queries) 8 January 4th 07 11:27 PM
Excel formula where I can add business days (date) kskaug1 Excel Discussion (Misc queries) 3 September 1st 06 07:59 PM
Need formula for: IF K1 = y then M1= the date in A1 + 15 days LizKiz Excel Worksheet Functions 2 December 14th 05 02:23 AM
formula to calculate future date from date in cell plus days Chicesq Excel Worksheet Functions 8 November 3rd 05 12:25 PM
Excel running date formula minus weekend days Eliane Excel Worksheet Functions 2 March 30th 05 10:37 PM


All times are GMT +1. The time now is 12:04 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"