Frank? Could you take a look?

  • Thread starter Thread starter Excel Newbie
  • Start date Start date
E

Excel Newbie

I have this so far--I just need a way to say that "if E7=1
and I2=2004 or I2=2008 or I2=2012 or I2=2016 or I2=2020 or
I2=2024, then "91" goes in the cell." I have the year as
Cell I2, and the user of the worksheet will change this as
necessary.

In other words, I need to account for leap years.
The formula I am using is below:

=IF(E7=1,"90",IF(E7=2,"91",IF(E7=3,"92", IF
(E7=4,"92","N/A"))))

The original post on this problem is
 
Hi
I already posted a solution using a simple subtraction of dates and let
Excel take care of leap years. See your older thread
 
Hey Newbie
This is a modification of Frank's formula from the other thread

=DATE(I2,E7*3+1,1)-DATE(I2,(E7-1)*3+1,1

Hi Frank, you missed a couple brackets on the YEAR functions. Do you work this late every night

Regards
Mark Graesse
(e-mail address removed)
Boston M

----- Excel Newbie wrote: ----



I have this so far--I just need a way to say that "if E7=1
and I2=2004 or I2=2008 or I2=2012 or I2=2016 or I2=2020 or
I2=2024, then "91" goes in the cell." I have the year as
Cell I2, and the user of the worksheet will change this as
necessary

In other words, I need to account for leap years
The formula I am using is below

=IF(E7=1,"90",IF(E7=2,"91",IF(E7=3,"92", I
(E7=4,"92","N/A")))

The original post on this problem is
 
Thank you, yes you did. However, I have o idea how to use
what you replied with in the older thread. I am an Excel
idiot, and your solution is incomprehensible to me.
 
Hi Mark
shouldn't create formulas on the fly :-)
For me it's not that late - just short before 10 pm.
 
Hi
just insert the formula I provided to you in a cell (though as Mark
pointed out I missed some brackets). If you still have problems email
me your sheet and I'll set-up an example for you
 
Clearly! 4282 posts last month! That's one every ten minutes for the entire month, WITHOUT sleep, weekends, or bathroom breaks!!!!!!!!!!!!!!!

Mark Graesse

----- Don Guillett wrote: ----

Frank is not a real person. He is a computer and never sleeps
 
.. That's one every ten minutes for the entire month, WITHOUT sleep,
weekends, or bathroom breaks!!!!!!!!!!!!!!!!

LOL! an incredible answer rate nonetheless ..
... thought 2442 (Feb' 04) was already sky-high ..
Frank's answering posts faster ..
... than the rate of queries being posted ??
... and does the 4282 include his posts in .public.de.excel?
... hmm ..

--
Rgds
Max
xl 97
---
Please respond, in newsgroup
xdemechanik <at>yahoo<dot>com
----
"Mark Graesser" < wrote
Clearly! 4282 posts last month!
That's one every ten minutes for the entire month, WITHOUT sleep,
Click to expand...
weekends, or bathroom breaks!!!!!!!!!!!!!!!!
 
Back
Top