Home |
Search |
Today's Posts |
#1
|
|||
|
|||
FILL DATES IN VARIOUS CELLS BASED ON A DATE ENTERED IN A SINGLE C.
I need to fill various series of cells based on the date entered in a single
cell. so if the last day of the month is entered in cell h3 , i will need to fill cells b14 through h14 ect. to include the entire month. this is a timesheet and I want the dates to auto populate based and the user entering the last date of the month |
#2
|
|||
|
|||
It's not clear what you want in b14 through h14 -- the next day, next week?
However, to hopefully point you in the right direction, to add days to a date, just use regular arithmetic. Something like: b14: =$h$3+1 (will get you the first day of the next month) c14: =$h$3+7 (will get you one week later) etc. -- Regards, Fred Please reply to newsgroup, not e-mail "dencrowell" wrote in message ... I need to fill various series of cells based on the date entered in a single cell. so if the last day of the month is entered in cell h3 , i will need to fill cells b14 through h14 ect. to include the entire month. this is a timesheet and I want the dates to auto populate based and the user entering the last date of the month |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding dates within a date range | Excel Worksheet Functions | |||
Date format of cells | Excel Discussion (Misc queries) | |||
Count cells in a column that contain dates | New Users to Excel | |||
Change a cell's fill color dynamically? | Excel Discussion (Misc queries) | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions |