Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

excel and days

Status
Not open for further replies.

fadge

Technical User
Apr 8, 2009
7
GB
is there a way that in excel it would be posible that when you format a cell / column that the day can also be displayed or at least known. The reason being is that i am creating an overtime pay sheet. I need different rates for weekdays and saturday and sunday. Any advice?
 
format(now(), "dd/mm/yyyy ddd")
or
format(now(), "dd/mm/yyyy dddd")
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top