Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 468
Default date problem

Hi, i need the date and day in C1, but only when i write something in C8. And
when i close the workbook, and open it again, the date to remain the same.

Ex:
Today is MONDAY 03.11.2008

When i write something in C8, "MONDAY 03.11.2008" to appear in C1.
If i close the workbook, i need the date to be saved.
If i open the workbook after 3 days, C1 to show me the same "MONDAY
03.11.2008"
Can it be done?
Thank you in advance.
 
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
Exel increment date problem wrt todays date. [email protected] Excel Worksheet Functions 1 November 11th 07 06:58 PM
Date Formula Problem - Leave date blank if Null Gayla Excel Worksheet Functions 5 April 24th 07 09:42 PM
Date problem cfi Excel Discussion (Misc queries) 0 February 1st 06 08:12 PM
date problem bill gras Excel Worksheet Functions 6 October 16th 05 07:38 AM
Date Problem Subs New Users to Excel 1 September 27th 05 01:35 AM


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