I am excel stupid

soxfan9353

New Member
Joined
Aug 9, 2018
Messages
7
So I need help, I am looking to speed up my time card and have it autofill the dates on my time card when input the weekending date.


I can forward you the spread sheet if you want so you can see what i am working with.

Thanks, John
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Hi,

Don't know how your sheet is laid out, may be you can adapt this to your needs:


Book1
ABCDEFGH
1Week Ending
28/12/20188/5/20188/6/20188/7/20188/8/20188/9/20188/10/20188/11/2018
Sheet176
Cell Formulas
RangeFormula
B2=$A2-(8-COLUMNS($B2:B2))


B2 formula copied to H2
 
Upvote 0
You can just enter the date in the last cell (for the last day of the week) and enter -1 in each cell before that. For example, last cell is H2, the one before will be =H2-1.
 
Upvote 0
If your "Week Ending" is on the Right side, then all you have to do is select that cell, grab the cell handle, little square at the lower right corner of cell, and drag it across to the left to autofill the dates backwards.


Book1
ABCDEFGH
5Week Ending
68/5/20188/6/20188/7/20188/8/20188/9/20188/10/20188/11/20188/12/2018
Sheet176


Drag H6 to A6, no formula needed.
 
Upvote 0
Got your message, why don't you post a sample of what you're working on with detailed description of what you want to achieve.

If you must post a sample workbook, you can upload it to a free file hosting site like Dropbox and post the link here.
 
Upvote 0
Ok,

For purpose of demonstration, in L4, put in this Sunday's date 8/12/2018

Then in B8, enter this formula:

=L$4-(7-ROWS(B$8:B8))

and copy down column.

Whenever the date changes in L4, Column B will auto populate the dates of the week prior, starting with Monday, leading up to the date in L4.

I suggest you remove the personal info and re-upload your file.

Let me know how this works for you.
 
Last edited:
Upvote 0
That's odd, I'm not getting that, just the Dates, using your upload sample.

Are you using the same file as the one you uploaded?
May be change Column B formatting to Date.


Book1
BCDEFGHIJKLMNO
4NAME:WEEK ENDING:8/12/2018
5
6JOBSTARTENDCOOK #134DUPAGE #701LAKE #150WILL # 176
7DATENAMETIMETIMEROTROTROTROTMILEAGEEXPENSES
88/6/2018
98/7/2018
108/8/2018
118/9/2018
128/10/2018
138/11/2018
148/12/2018
Sheet1
Cell Formulas
RangeFormula
B8=L$4-(7-ROWS(B$8:B8))
 
Upvote 0

Forum statistics

Threads
1,213,482
Messages
6,113,915
Members
448,532
Latest member
9Kimo3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top