I recently started working on a saturday and sunday and wanted to keep track of the hours i did and money i earned, is there any way to make it recognise a pattern? for example 30/11 1/12 7/12 8/12 ? Thanks for any help.
I recently started working on a saturday and sunday and wanted to keep track of the hours i did and money i earned, is there any way to make it recognise a pattern? for example 30/11 1/12 7/12 8/12 ? Thanks for any help.
Hi and welcome to the forum
This will give you the day number...
=WEEKDAY("date",2)
6 = Saturday and 7 = sunday, so you could probably workl something out using that and an IF() or sumif() statement?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Could you elaborate? I've not used excel massively. And also thank you!
Sure. Do you have a sample workbook showing what you are working with (and showing what you want)? It will make it easier to custom-fit something for you
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
Hi Deasy and welcome to the forum,
If you add a 1 to a date it gives the next day. Adding 7 will add 7 days. See the attached where I put in 11/30/20103 and 12/1/2013 and then did formulas for all the rest of the dates. Hope this helps.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Hours and pay.xlsx I want to be able to put all of the dates in for saturdays and sundays, without having manullay put them in
Yes MarvinP that's perfect thank you, and thank you too FDibbins.
Thanks. Slight mis-understanding...try this in A3, copied down...
=A2+IF(WEEKDAY(A2,2)=6,1,6)
As a test, put it in column B to make sure it matches your data?
Hi Deasy,
Here is how I'd do this problem. See the attached.
Nice option, Marvin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks