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: 1
Default display date of today in cell X when number 0 in cell Y

Hello, I am using excel 2007 and I am figuring out a way to display
the date of today (and 'capture' it) in one cell Y when there is a
number (0) entered in an other cell X.
The thing is that, when I open the excel sheet tomorrow, the date
displayed in Y still has to be the date of today and not have changed
in tomorrow's date.
Background : the purpose of the xls sheet is to create a sort of
logbook with entry's of file numbers and their entry/close dates.
....Sorry if this turns out to be a silly question : I'm just began to
learn Excel, so every help on my learning path is more than
appreciated.
 
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
Populate Cell with another cell, but only if the date equals today GaryS Excel Worksheet Functions 4 May 1st 08 04:39 AM
IF TODAY equals date in cell A10, or if TODAY is beyond that date SoupNazi Excel Worksheet Functions 4 April 23rd 07 01:14 AM
I want to copy a cell by date if Cell = Today() then... quickquestion Excel Discussion (Misc queries) 3 May 16th 06 01:12 PM
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
Turn cell red if today is greater or equal to date in cell Rich New Users to Excel 2 December 7th 04 10:50 PM


All times are GMT +1. The time now is 08:19 PM.

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"