Excel,how do i key in a function to fixed staff off's day on my excel sheet?

Answer If you have the dates, You can use the weekday function to determine what day it is. Next you create some fancy compound formula like=IF(OR(WEEKDAY(A1,2)=1,WEEKDAY(A1,2)=7…

Top Q&A For: Excel,how do i key in a function to fixed staff...

Search function in excel alongside of a time/date function?

dont worry about the AM and PM....the Am and PM are only formatting....they arent really part of the number or just need to check if your times go past midnight...and add 1 if it i... Read More »

Excel 2007: How to Import Data From One Excel Sheet to Another?

In computing terms, a "spreadsheet" is a type of large table that is used to display information. Microsoft Excel 2007 is just one of the many programs that is capable of creating and working with ... Read More »

How to Split Multi Sheet Workbook Excel Into Single Excel File using Excelsplitter?

Work with hundreds of sheets in one excel file,instead of copying and pasting every sheet in a new file one by one.

How to insert a work sheet to the right hand side of the last work sheet in the Excel file?

You did not specify which version of MS-Excel you are using, for there is a difference in the steps involved.In 2007, just use the special "Insert Worksheet" tab located on the far right of all of ... Read More »