Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Using IF & AND and getting #NAME?

1 view
Skip to first unread message

perplexed

unread,
Sep 5, 2007, 10:40:59 PM9/5/07
to
To determine if a date falls within a time period, I created this
function, but keep getting #NAME? for the result.

=IF(AND(7/1/2005<=AE,AE<=6/30/2006),"FY2005","NA")

This function is in AF, where the result would be placed.

I will appreciate advice what is wrong or missing with this function?

Thanks!

0 new messages