Use todays date as criteria to select workdays older than 2 days.

**tanktata** · 03-05-2012, 02:47 PM

I have a spreadsheet which has several rows of data. Each row has, in column A, the date the data is entered.

I would like to use this date information to select the rows which were entered over 2 days ago, but only using monday - friday.

I have tried using WORKDAYS and NETWORKDAYS functions, but since these need to be installed via the analysis add in and the workbook is going to be used by different people on different PC's, I was wondering if there was an alternative.

Thanks in advance.

**Pepe Le Mokko** · 03-05-2012, 03:52 PM

Which is your XL versiion?

**tanktata** · 03-05-2012, 03:53 PM

Originally Posted by Pepe Le Mokko

Which is your XL versiion?

excel 2003

**Pepe Le Mokko** · 03-05-2012, 04:22 PM

To count the number of days, without week ends you can use the following array formula

Please Login or Register  to view this content.

where A1 is the date when data was entered

This formula does not account for holidays and should be committed with Ctrl+Shift+Enter

**daddylonglegs** · 03-05-2012, 04:33 PM

This formula will replicate networkdays without holidays considered

=SUM(INT((WEEKDAY(A2-{2,3,4,5,6})+TODAY()-A2)/7))

that's the equivalent of

=NETWORKDAYS(A2,TODAY())

**tanktata** · 03-06-2012, 02:23 PM

Thanks for the help. What is the best way to use this new formula?

I have a macro which loops through every row in a worksheet, and then copies the row to a summary sheet if it is over 2 days old.

I was going to add the formula to the end of each row. This will display how many days old the row is, and therefore decide wether the row needed to be copied.

Heres what I have so far. It seems to work OK but I wondered if there were a better way to do it.

Please Login or Register  to view this content.

**Pepe Le Mokko** · 03-06-2012, 03:58 PM

Please start a new thread

Use todays date as criteria to select workdays older than 2 days.

LinkBack

Thread Tools

Rate This Thread

Display

Use todays date as criteria to select workdays older than 2 days.

Re: Use todays date as criteria to select workdays older than 2 days.

Re: Use todays date as criteria to select workdays older than 2 days.

Re: Use todays date as criteria to select workdays older than 2 days.

Re: Use todays date as criteria to select workdays older than 2 days.

Re: Use todays date as criteria to select workdays older than 2 days.

Re: Use todays date as criteria to select workdays older than 2 days.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions