Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
CrimsonPlague29
 
Posts: n/a
Default Date Functions

Hello,

I would like to be able to have the following happen. If Part # cell is
blank then Completed Date is blank, but if a value is entered into the part #
cell I would like to have the current date appear in the Completed Date cell,
and to stay that date. Currently once midnight comes the date changes.

Sample chart:
Part # Request Date Completed Date

1234 April 23/06

Thanks
 
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
Another Date issue. TimM Excel Worksheet Functions 1 November 17th 05 01:58 AM
Advanced Date Functions enright_m Excel Worksheet Functions 1 October 26th 05 04:08 PM
NETWORKDAYS - Multiple Date Selection Annabelle Excel Discussion (Misc queries) 3 October 4th 05 07:04 PM
How do I calculate if a date is in a certain time frame? Pe66les Excel Worksheet Functions 19 August 27th 05 11:07 PM
Date functions John New Users to Excel 3 August 15th 05 08:50 PM


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