Find date on different Sheet in excel and perform some actions?

Answer As long as the dates in column A are really in the MS-Excel Date data type (and not plain Text), then the DATE() function may be used to obtain the current computer date and compare against a cell ... Read More »

Top Q&A For: Find date on different Sheet in excel and perfo...

How to Use a List of Options in Excel on a Different Sheet?

Microsoft Excel Data Validation can be used to make drop-down lists. These lists can refer to a single cell or a range of cells. This range can be present in a different worksheet within the same w... 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.

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

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…