how do i set up a formulas with an if date?
 

I need help.
I am trying to set up several worksheets in excel to draw information from
my main worksheet. I need to set up an IF formula if the date is within a
cerain year then fill into a certain worksheet. I tried using Access but
could not get the formatting i needed. Is this even possible?

Thanks

If the date is in cell A1, something like:

=IF(YEAR(A1)=1966,"the year you were born","sometime later in life")

Regards

Trevor


"Thunley" wrote in message
...
I need help.
I am trying to set up several worksheets in excel to draw information from
my main worksheet. I need to set up an IF formula if the date is within
a
cerain year then fill into a certain worksheet. I tried using Access but
could not get the formatting i needed. Is this even possible?

Thanks

What if the date is mm/dd/yy and if it falls in a fiscal year then it shows
on that spreadsheet if not then it reads the next entry and so forth with
many spreadsheets in the workbook to look at the dates from the original
spreadsheet?
Tammy

"Trevor Shuttleworth" wrote:

If the date is in cell A1, something like:

=IF(YEAR(A1)=1966,"the year you were born","sometime later in life")

Regards

Trevor


"Thunley" wrote in message
...
I need help.
I am trying to set up several worksheets in excel to draw information from
my main worksheet. I need to set up an IF formula if the date is within
a
cerain year then fill into a certain worksheet. I tried using Access but
could not get the formatting i needed. Is this even possible?

Thanks

Then you have to set the parameters for the fiscal year, I would use a help
column in the main workbook
where I would tag the fiscal year, then filter and copy visible cells to the
new workbook and so on

=AND(A2=--"01/04/03",A2<=--"03/31/04")

will return TRUE for fiscal year 2003 (assuming the fiscal years starts on
Apr )
where A2 holds the first date, then copy down as long as needed, apply the
autofilter
and filter on the help column and filter on TRUE, select and press F5 and
special and visible cells only
copy and paste

--

Regards,

Peo Sjoblom

"Thunley" wrote in message
...
What if the date is mm/dd/yy and if it falls in a fiscal year then it
shows
on that spreadsheet if not then it reads the next entry and so forth with
many spreadsheets in the workbook to look at the dates from the original
spreadsheet?
Tammy

"Trevor Shuttleworth" wrote:

If the date is in cell A1, something like:

=IF(YEAR(A1)=1966,"the year you were born","sometime later in life")

Regards

Trevor


"Thunley" wrote in message
...
I need help.
I am trying to set up several worksheets in excel to draw information
from
my main worksheet. I need to set up an IF formula if the date is
within
a
cerain year then fill into a certain worksheet. I tried using Access
but
could not get the formatting i needed. Is this even possible?

Thanks