| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
incrementing a date that the user has entered?
Simple solution...in B1 enter =a1+1. grab handle afterwards and drag
across. "pano" wrote in message ups.com... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
incrementing a date that the user has entered?
In B1: =IF(A1="","",A1+1)
Copy B1 across to F1 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- pano wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
incrementing a date that the user has entered?
Hi Pano:
=IF(A1="","",A1+1--(WEEKDAY(A1,1)=7)) But this in B2 and then copy across. Ie it assumes that you don't want a Sunday. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "pano" wrote: 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
incrementing a date that the user has entered?
Martin this works really well
=IF(A1="","",A1+1--(WEEKDAY(A1,1)=7)) thanks stephen Martin Fishlock wrote: Hi Pano: =IF(A1="","",A1+1--(WEEKDAY(A1,1)=7)) But this in B2 and then copy across. Ie it assumes that you don't want a Sunday. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "pano" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can excel automatically enter the date data in a cell was entered | Excel Worksheet Functions | |||
| Check input is a date | Excel Discussion (Misc queries) | |||
| Mileage Claim Formula | New Users to Excel | |||
| excel, automatic date and time when info gets entered | Excel Worksheet Functions | |||
| Capture and Store the date that data is entered in Excel? | Excel Worksheet Functions | |||
Linear Mode
