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: 84
Default incrementing a date that the user has entered?

Hi,
in A1 the user types a date, I then need a formula in b1 which takes
the date the user has entered and increments by one day across c1 d1 e1
f1.

The day the user enters will always be a monday thru to Saturday.
A1 B1 C1 D1 E1
USER Auto Fill AUto Fill Auto Fill etc
22-Jan-07 23-Jan-07 24-Jan 07 25-Jan-07


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
can excel automatically enter the date data in a cell was entered mg_sv_r Excel Worksheet Functions 4 September 5th 08 11:09 AM
Check input is a date stumac Excel Discussion (Misc queries) 5 December 14th 06 03:28 PM
Mileage Claim Formula johndavies New Users to Excel 4 August 14th 06 09:24 AM
excel, automatic date and time when info gets entered shorty Excel Worksheet Functions 4 April 26th 06 06:46 PM
Capture and Store the date that data is entered in Excel? Nicegy Excel Worksheet Functions 2 August 10th 05 12:58 AM


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