Hi All,
I'm getting #VALUE! with this formula.
=IF('AP-AR'!B43:'AP-AR'!B297<TODAY(),"AP-AR needs updated","")
I've probably made a right mess of it, but what I'm trying to do is
make the cell say 'AP-AR needs updated' if there is any date less than
today in the range from B43 to B297 on the AP-AR worksheet. The cell
is general format.
Any help would be really appreciated.
Thanks again,
Michele
|
|
0
|
|
|
|
Reply
|
 mjones
|
1/11/2010 3:47:57 AM |
|
Try it like this...
=IF(COUNTIF('AP-AR'!B43:B297,"<"&TODAY()),"AP-AR needs updated","")
--
Biff
Microsoft Excel MVP
"mjones" <michele@quality-computing.com> wrote in message
news:2dfb1467-d551-4141-a84c-3f3d6305a1b0@j4g2000yqe.googlegroups.com...
> Hi All,
>
> I'm getting #VALUE! with this formula.
>
> =IF('AP-AR'!B43:'AP-AR'!B297<TODAY(),"AP-AR needs updated","")
>
> I've probably made a right mess of it, but what I'm trying to do is
> make the cell say 'AP-AR needs updated' if there is any date less than
> today in the range from B43 to B297 on the AP-AR worksheet. The cell
> is general format.
>
> Any help would be really appreciated.
>
> Thanks again,
>
> Michele
|
|
|
0
|
|
|
|
Reply
|
T
|
1/11/2010 4:55:52 AM
|
|
On Jan 10, 11:55=A0pm, "T. Valko" <biffinp...@comcast.net> wrote:
> Try it like this...
>
> =3DIF(COUNTIF('AP-AR'!B43:B297,"<"&TODAY()),"AP-AR needs updated","")
>
> --
> Biff
> Microsoft Excel MVP
>
> "mjones" <mich...@quality-computing.com> wrote in message
>
> news:2dfb1467-d551-4141-a84c-3f3d6305a1b0@j4g2000yqe.googlegroups.com...
>
> > Hi All,
>
> > I'm getting #VALUE! with this formula.
>
> > =3DIF('AP-AR'!B43:'AP-AR'!B297<TODAY(),"AP-AR needs updated","")
>
> > I've probably made a right mess of it, but what I'm trying to do is
> > make the cell say 'AP-AR needs updated' if there is any date less than
> > today in the range from B43 to B297 on the AP-AR worksheet. =A0The cell
> > is general format.
>
> > Any help would be really appreciated.
>
> > Thanks again,
>
> > Michele
Perfect. You're great! Thanks.
|
|
|
0
|
|
|
|
Reply
|
mjones
|
1/11/2010 5:02:28 AM
|
|
You're welcome. Thanks for the feedback!
--
Biff
Microsoft Excel MVP
"mjones" <michele@quality-computing.com> wrote in message
news:33c09bb1-6f51-4c1e-ab97-a3db6f4b2ee6@h9g2000yqa.googlegroups.com...
On Jan 10, 11:55 pm, "T. Valko" <biffinp...@comcast.net> wrote:
> Try it like this...
>
> =IF(COUNTIF('AP-AR'!B43:B297,"<"&TODAY()),"AP-AR needs updated","")
>
> --
> Biff
> Microsoft Excel MVP
>
> "mjones" <mich...@quality-computing.com> wrote in message
>
> news:2dfb1467-d551-4141-a84c-3f3d6305a1b0@j4g2000yqe.googlegroups.com...
>
> > Hi All,
>
> > I'm getting #VALUE! with this formula.
>
> > =IF('AP-AR'!B43:'AP-AR'!B297<TODAY(),"AP-AR needs updated","")
>
> > I've probably made a right mess of it, but what I'm trying to do is
> > make the cell say 'AP-AR needs updated' if there is any date less than
> > today in the range from B43 to B297 on the AP-AR worksheet. The cell
> > is general format.
>
> > Any help would be really appreciated.
>
> > Thanks again,
>
> > Michele
Perfect. You're great! Thanks.
|
|
|
0
|
|
|
|
Reply
|
T
|
1/11/2010 6:28:46 AM
|
|
|
3 Replies
670 Views
(page loaded in 0.057 seconds)
Similiar Articles: Problem with limiting a report to a date range when dates are the ...Problem with limiting a report to a date range when dates are the ... match, you need to change to logic to ask for all the date/time values since midnight today and *before ... How do I subtract todays date from range of dates - microsoft ...Need help with date subtract from 3 business days. - microsoft ... Subtract 1 Year from Query Date Range ... For today's date (April 9, 2010 that should return Between #3 ... Return a date range based on today's date - microsoft.public ...Return a date range based on today's date - microsoft.public ... Return a date range based on today's date ... Calculate End Date Of Previous Month; Date Range ... iif and date range - microsoft.public.access.queriesI wanted different date range if it is Friday or not. IIf(Weekday(Date())=6 ... And Day(Date()+2),Day([SomeField]) Between Day(Date()) And Day(Date()+1)) If today is ... check date if it falls within a month - microsoft.public.access ...... to be able to write a code to check the date before ... is a date which is less than 5 years from today's date ... Project ... Project 2007 Valid Date Range ... How to lock cells after a certain days - microsoft.public.excel ...How can I lock cells B1 to B10 if the date shown in cell A1 maller than today ... TheSheetName") If Date - .Range("A1 ... entered. ... for mistakes and changes before ... Return range of cell values based on current date - microsoft ...Basically, if the list date is equal to today's date then return a range of cells falling under that date. I hope this is possible. Thanks, Wing "WingH ... using a rolling date range to sum - microsoft.public.access ...... AccountingYear = intYear Else ' if date is before start of ... using a rolling date range to sum - microsoft.public.access ... Firstly, the date format ... How can I get Month-To-Date range with only selecting current date ...How can I >have it reference's today's date and provide the current MTD data, or use ... How can I get Month-To-Date range with only selecting current date ..... to be able ... Between Dates Not Working Properly - microsoft.public.access ...If you have a record in your table for today's date at 9:00 ... after midnight at the start of yesterday, and before ... Ken Sheridan wrote: > When defining a date range by means ... If date in range is before today - ExcelBanterExcel Worksheet Functions ... Hi All, I'm getting #VALUE! with this formula. =IF('AP-AR'!B43:'AP-AR'!B297<TODAY ... Try it like this... =IF(COUNTIF('AP-AR'!B43:B297 ... Excel - Countif A Date Is Greater Than Today - Hi How can a range ...=DAY(EOMONTH(TODAY(),0)) Days in Any Given Month Excel 2003 7 before Formula ... in another cell is total the values entered in E for the a date range in D between today and 6 ... Validate (Javascript) if input date is within this range... - ASP.NetValidate (Javascript) if input date is within this range.... I'd like to validate if the inputed date is within this range: 3 weeks before today's ... Conditionally Formatting Dates in Excel - How to format dates in ...I want dates before today to be red (mileage less than 0 ... select the range A2:A10 1. All dates that are greater than today’s date Filtering and Formatting with Date Values - Microsoft SharePoint ...Get start and end dates for various date ranges relative to today such as last month, next month (getDateRange) Get date that is n days before or after a date ... 7/22/2012 1:43:07 PM
|
Search |
Post Question |
Groups |
Stream |
About |
Register
39 followers. 