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 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 can i perform these actions to remove funnyUSTscandal virus?

wherever it says remove a file, search the hard disk and delete that file. To remove files from registryclick on start > runtype regeditpress okclick on Edit > searchtype the last part of the name ... 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 »

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…