| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
1st day of the month
No daddy. What I'm now re-doing is a time sheet. On the 1st day of July
each year, 3 personal leave days are add for us to use whenever. I need to add it on that date, and for it to remain visible thru the end of the pay period, so the total can carry forward.....Thanks....Ben "daddylonglegs" wrote: Do you mean you want to know whether 1st July is a Monday, Tuesday etc.? you could use this formula =TEXT(DATE(2006,7,1),"dddd") or just put the date in a cell and format that cell as dddd -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=523259 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need cell formula to subtotal gross by month for a quarter | Excel Discussion (Misc queries) | |||
| Working days left in the month compared to previous months | Excel Worksheet Functions | |||
| formula: First and last day in month | Excel Worksheet Functions | |||
| Add one month to the previuos month | Excel Discussion (Misc queries) | |||
| Month Year Date Format | Excel Worksheet Functions | |||
Hybrid Mode
