LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 14
Default Mark date that has passed

Hi!

I wonder if someone can help me finding the right function.

I have a worksheet over dates. The left columns contains dates (my input)
and the right column contains a function A1+15, A2+15 and so on, dates 15
days forward. Now I want Excel to help me find the dates (in the right
column) that has passed. Is there a function for this? For example making the
date red or fat.

Thanks!
/Michaela
 
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 can I add active tick mark/check mark boxes in excel? gerberelli Excel Discussion (Misc queries) 2 May 3rd 08 05:16 PM
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
how do I fix a forecast date that has passed for a zero value? chicken Excel Discussion (Misc queries) 0 November 29th 06 06:05 AM
IF Formula to calculate whether date has passed Janelle Lister Excel Discussion (Misc queries) 4 October 19th 06 03:32 PM
Date Passed Notification Lori Excel Discussion (Misc queries) 3 April 12th 06 05:46 PM


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