LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default vba date XL2000

I am looking for a sheet code that puts tomorrow's date in the cell
bellow today's date
after a value is imputed in the row of today's date

today is A1 7/12/03 and cell D1 is empty when i put a value in D1 i
want tomorrows date in A2
now lets say today is 7/13/03 and D2 is empty and it stays empty then no
date will go into A3
now lets say today is 7/14/03 and D2 is empty when i put a value in D2 i
want tomorrow's date in A3
now lets say today is 7/15/03 and D3 is empty when i put a value in D3 i
want tomorrow's date in A4

 
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
XL2000 - Sumproduct Question LPS Excel Worksheet Functions 3 November 24th 08 07:09 PM
XL2000 CF and Comparing Lists LPS Excel Worksheet Functions 6 October 2nd 08 04:50 PM
XL2000, CF and List Comparisons LPS Excel Worksheet Functions 3 September 29th 08 07:41 PM
Workday function in XL2000 Steve[_4_] Excel Worksheet Functions 3 March 12th 08 08:54 AM
XL2000: "Filename is Not Valid" Steve Excel Discussion (Misc queries) 0 June 22nd 05 10:06 PM


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