IF statement for two conditions of dates - prior date and then prior three days

**LALTIZER** · 02-26-2015, 05:18 PM

This formula =COUNTIF(Data!A:A,E1-1) is correct if the day of week is Tuesday, Wednesday, Thursday., or Friday, but I need another condition to bring back the counts if it is Monday then the count should be the prior three days counts (Sunday, Saturday, and Friday).

I have created this IF statement below for both conditions, but it is not working correctly:

=IF(F1="Monday",(COUNTIF(Datal!A:A,E1-3)-COUNTIF(Data!A:A,E1-1)),COUNTIF(Data!A:A,E1-1))

It only brought back Sunday count

02/23/15 Monday

Daily Count Daily Amt
4 $217.827.84

I have attach an excel spreadsheet with the data to help.

Thanks

**skywriter** · 02-26-2015, 06:12 PM

I'm getting an answer of 1, which looks right to me based on your data. What's the issue? The date in E1 2/23/2015 is Monday so the formula is counting the number E-3 which is 2/20/2015 which is 5 and subtracting the number of E-1, which 2/22/2015 and there are 4 of those in your data, so the result is 1.

IF statement for two conditions of dates - prior date and then prior three days

LinkBack

Thread Tools

Rate This Thread

Display

IF statement for two conditions of dates - prior date and then prior three days

Re: IF statement for two conditions of dates - prior date and then prior three days

Thread Information

Users Browsing this Thread

Similar Threads

Date Countdown with colors for expired and 30 days prior

sending an email 7 days prior to a due date

Set alert 30 days prior to date

Excel 2007 : Need to know how to set an alert to show 30 days prior to the date in each cell.

shade a cell 3 days prior to an appointment date?

Bookmarks

Bookmarks

Posting Permissions