| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Date & Day of Week
I have a simple time sheet for calculating my hours worked for a two week pay period. In one column, I have the dates of the pay period. In the next column, I have the day of the week. Is there a formula I can use that will auto insert the day of the week according to the date I insert in the date column? DATE WEEKDAY D4=Date E4=??? Thanx. -- Ltat42a ------------------------------------------------------------------------ Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735 View this thread: http://www.excelforum.com/showthread...hreadid=397223 |
|
#2
|
|||
|
|||
|
Hi
Use =D4 in cell E4 Then format the cell like this Select E4 FormatCells in the men bar Custom on the number tab and fill in dddd -- Regards Ron de Bruin http://www.rondebruin.nl "Ltat42a" wrote in message ... I have a simple time sheet for calculating my hours worked for a two week pay period. In one column, I have the dates of the pay period. In the next column, I have the day of the week. Is there a formula I can use that will auto insert the day of the week according to the date I insert in the date column? DATE WEEKDAY D4=Date E4=??? Thanx. -- Ltat42a ------------------------------------------------------------------------ Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735 View this thread: http://www.excelforum.com/showthread...hreadid=397223 |
|
#3
|
|||
|
|||
|
Ron de Bruin Wrote: Hi Use =D4 in cell E4 Then format the cell like this Select E4 FormatCells in the men bar Custom on the number tab and fill in dddd -- Regards Ron de Bruin http://www.rondebruin.nl "Ltat42a" wrote in message ... I have a simple time sheet for calculating my hours worked for a two week pay period. In one column, I have the dates of the pay period. In the next column, I have the day of the week. Is there a formula I can use that will auto insert the day of the week according to the date I insert in the date column? DATE WEEKDAY D4=Date E4=??? Thanx. -- Ltat42a ------------------------------------------------------------------------ Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735 View this thread: http://www.excelforum.com/showthread...hreadid=397223 Very cool - works great. Thanx!!! -- Ltat42a ------------------------------------------------------------------------ Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735 View this thread: http://www.excelforum.com/showthread...hreadid=397223 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date, Day of week | Excel Worksheet Functions | |||
| 52 week average based on date | Excel Discussion (Misc queries) | |||
| How can I convert a date into a week number... | Excel Worksheet Functions | |||
| conditional formula to recognize day of the week from date | Excel Discussion (Misc queries) | |||
| I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
Linear Mode
