I am excel stupid

[soxfan9353]

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

 

[jtakw]

Remove personal info, upload the file that shows the 0:00 with my formula in place and post a link, I'll check it out.

 

[soxfan9353]

[TABLE="width: 852"]<colgroup><col width="69"><col width="164"><col width="53" span="2"><col width="39" span="8"><col width="57"><col width="65"><col width="57"><col width="22"></colgroup><tbody>[TR][TD="width: 69"][/TD][TD="width: 164"][/TD][TD="width: 53"][/TD][TD="class: xl110, width: 248, colspan: 6, align: center"]EMPLOYEE TIME SHEET[/TD][TD="width: 39"][/TD][TD="width: 39"][/TD][TD="width: 39"][/TD][TD="width: 57"][/TD][TD="width: 65"][/TD][TD="width: 57"][/TD][TD="width: 22"][/TD][/TR][TR][TD][/TD][TD][/TD][TD][/TD][TD][/TD][TD][/TD][TD][/TD][TD="class: xl99, width: 179, colspan: 3, align: center"][/TD][TD][/TD][/TR][TR][TD][/TD][TD][/TD][TD][/TD][TD="class: xl98, align: center"][/TD][TD="class: xl98, align: center"][/TD][TD="class: xl98, align: center"][/TD][TD="class: xl98, align: center"][/TD][TD="class: xl98, align: center"][/TD][TD="class: xl98, align: center"][/TD][TD][/TD][TD][/TD][TD][/TD][TD="class: xl99, width: 57, align: center"][/TD][TD="class: xl100, align: center"][/TD][TD="class: xl100, align: center"][/TD][TD][/TD][/TR][TR][TD="class: xl77"]NAME:[/TD][TD="class: xl111, colspan: 3, align: center"]Bailey, John[/TD][TD="class: xl68"] [/TD][TD="class: xl68"] [/TD][TD="class: xl68"] [/TD][TD="class: xl78, colspan: 3"] WEEK ENDING:[/TD][TD="class: xl112, colspan: 4, align: center"]8/12/18[/TD][TD="class: xl90"] [/TD][TD][/TD][/TR][TR][TD="class: xl69"] [/TD][TD][/TD][TD][/TD][TD][/TD][TD][/TD][TD][/TD][TD][/TD][TD][/TD][TD][/TD][TD][/TD][TD][/TD][TD][/TD][TD][/TD][TD] [/TD][TD="class: xl92"] [/TD][TD][/TD][/TR][TR][TD="class: xl75, align: center"] [/TD][TD="class: xl73, align: center"]JOB[/TD][TD="class: xl73, align: center"]START[/TD][TD="class: xl82, align: center"]END[/TD][TD="class: xl83"] COOK #134[/TD][TD="class: xl84, align: center"] [/TD][TD="class: xl86, colspan: 2"]DUPAGE #701[/TD][TD="class: xl86, colspan: 2"] LAKE #150[/TD][TD="class: xl86, colspan: 2"]WILL # 176[/TD][TD="class: xl96"] [/TD][TD="class: xl72"] [/TD][TD="class: xl93"] [/TD][TD][/TD][/TR][TR][TD="class: xl76, align: center"]DATE[/TD][TD="class: xl74, align: center"]NAME[/TD][TD="class: xl74, align: center"]TIME[/TD][TD="class: xl74, align: center"]TIME[/TD][TD="class: xl74, align: center"]R[/TD][TD="class: xl74, align: center"]OT[/TD][TD="class: xl74, align: center"]R[/TD][TD="class: xl74, align: center"]OT[/TD][TD="class: xl74, align: center"]R[/TD][TD="class: xl81, align: center"]OT[/TD][TD="class: xl74, align: center"]R[/TD][TD="class: xl88, align: center"]OT[/TD][TD="class: xl89, align: center"]MILEAGE[/TD][TD="class: xl89, align: center"]EXPENSES[/TD][TD="class: xl94, align: center"]PARKING[/TD][TD][/TD][/TR][TR][TD="class: xl97, align: right"]8/6/18[/TD][TD="class: xl67"] [/TD][TD="class: xl105, align: center"] [/TD][TD="class: xl105, align: center"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl80"] [/TD][TD="class: xl67"] [/TD][TD="class: xl80"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl95"] [/TD][TD][/TD][/TR][TR][TD="class: xl97, align: right"]8/7/18[/TD][TD="class: xl67"] [/TD][TD="class: xl101"] [/TD][TD="class: xl101"] [/TD][TD="class: xl67"] [/TD][TD="class: xl102"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl80"] [/TD][TD="class: xl67"] [/TD][TD="class: xl80"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl95"] [/TD][TD][/TD][/TR][TR][TD="class: xl97, align: right"]8/8/18[/TD][TD="class: xl67"] [/TD][TD="class: xl101"] [/TD][TD="class: xl101"] [/TD][TD="class: xl67"] [/TD][TD="class: xl104, width: 39"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl80"] [/TD][TD="class: xl67, align: right"]8[/TD][TD="class: xl80"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl95"] [/TD][TD][/TD][/TR][TR][TD="class: xl97, align: right"]8/9/18[/TD][TD="class: xl67"] [/TD][TD="class: xl101"] [/TD][TD="class: xl101"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl80"] [/TD][TD="class: xl67, align: right"]8[/TD][TD="class: xl80"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl95"] [/TD][TD][/TD][/TR][TR][TD="class: xl97, align: right"]8/10/18[/TD][TD="class: xl115"][/TD][TD="class: xl101"] [/TD][TD="class: xl101"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl80"] [/TD][TD="class: xl67, align: right"]8[/TD][TD="class: xl80"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl95"] [/TD][TD][/TD][/TR][TR][TD="class: xl108, align: right"]8/11/18 0:00[/TD][TD="class: xl103, align: center"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl106"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl80"] [/TD][TD="class: xl67"] [/TD][TD="class: xl80"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl95"] [/TD][TD][/TD][/TR][TR][TD="class: xl107, align: right"]8/12/18 0:00[/TD][TD="class: xl103, align: center"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl80"] [/TD][TD="class: xl67"] [/TD][TD="class: xl80"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl95"] [/TD][TD][/TD][/TR][TR][TD="class: xl70"] [/TD][TD="class: xl103, align: center"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl80"] [/TD][TD="class: xl67"] [/TD][TD="class: xl80"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl95"] [/TD][TD][/TD][/TR][TR][TD="class: xl70"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl80"] [/TD][TD="class: xl67"] [/TD][TD="class: xl80"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl95"] [/TD][TD][/TD][/TR][TR][TD="class: xl70"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl80"] [/TD][TD="class: xl67"] [/TD][TD="class: xl80"] [/TD][TD="class: xl67"] [/TD][TD="class: xl67"] [/TD][TD="class: xl95"] [/TD][TD][/TD][/TR][TR][TD="class: xl113, colspan: 2, align: center"]TOTAL HOURS[/TD][TD="class: xl71, bgcolor: gray"] [/TD][TD="class: xl71, bgcolor: gray"] [/TD][TD="class: xl79, align: right"]0[/TD][TD="class: xl79, align: right"]0[/TD][TD="class: xl79, align: right"]0[/TD][TD="class: xl79, align: right"]0[/TD][TD="class: xl79, align: right"]0[/TD][TD="class: xl79, align: right"]0[/TD][TD="class: xl79, align: right"]24[/TD][TD="class: xl79, align: right"]0[/TD][TD="class: xl79"] [/TD][TD="class: xl79"] [/TD][TD="class: xl79"] [/TD][TD][/TD][/TR][TR][TD][/TD][TD="class: xl65"][/TD][TD][/TD][TD][/TD][TD][/TD][TD][/TD][TD][/TD][TD][/TD][TD][/TD][TD][/TD][TD][/TD][TD][/TD][TD][/TD][TD][/TD][TD][/TD][TD][/TD][/TR][TR][TD][/TD][TD="class: xl66, align: right"]REGULAR HOURS[/TD][TD="class: xl79, align: right"]24[/TD][TD][/TD][TD="class: xl66, align: right"]MILES[/TD][TD="class: xl79, align: right"]0[/TD][TD][/TD][TD="class: xl66, align: right"]PARKING[/TD][TD="class: xl79, align: right"]0[/TD][TD][/TD][TD="colspan: 2"]SIGNATURE[/TD][TD="class: xl109, colspan: 3, align: center"] [/TD][TD][/TD][/TR][TR][TD][/TD][TD="class: xl66, align: right"]OVERTIME HOURS[/TD][TD="class: xl91, align: right"]0[/TD][TD="class: xl65"][/TD][TD="class: xl66, align: right"]EXPENSES[/TD][TD="class: xl91, align: right"]0[/TD][TD][/TD][TD][/TD][TD][/TD][TD][/TD][TD]DATE[/TD][TD="class: xl109, colspan: 4, align: center"] [/TD][TD][/TD][/TR]</tbody>[/TABLE]=L$4-(7-ROWS(B$8:B13))

 

[soxfan9353]

I don't know what is going on, i try to upload the workbook and it doesn't post. Honestly I don't know how to post a work book

 

[jtakw]

? Just do the same as you did in Post #6 .

 

[soxfan9353]

https://drive.google.com/file/d/16G75wg54mJpEo1Ep9r4ThJMceZQqHnFD/view?usp=sharing

 

[Joe4]

I don't know what is going on, i try to upload the workbook and it doesn't post. Honestly I don't know how to post a work book

It posted just fine. You just need to read the message that it popped back to you that states that your post requires Moderator approval before you can see them on the public forums. Please be patient and wait for approval and do not attempt to post it again (I deleted your duplicate attempt).

This is done on noob accounts to control Spam that is often posted in links and images. A few more posts, and your account will not be subject to this restrictions anymore.

 

[jtakw]

Somehow you got B13:B14 Custom Formatted Date/Time, that's why I had suggested for you to check the formatting in my Post #9 .

Either highlight B13:B14, right click, format cells, choose "Date", OK

Or, select B8, drag the cell handle down (little square at lower right corner of cell) to B14.

Either way will fix it.