Conditional Formula based on system date?

  • Thread starter Thread starter Newbie
  • Start date Start date
N

Newbie

Could someone please tell me how to construct a
conditional formula based on date or on your computer's
system date? Is this even considered a conditional
formula?

I would like to program a function that enters a certain
value if the date (either based on an updated cell date
entry or on system date) is within one range, another
value if the date is within another range, etc.

I really have no experience with this type of formula.

Thank you.
 
It's a lot worse than I thought; I need big help here.

I have a worksheet in which one column is listing which
quarter of the year we are in (first, second, third
fourth) and I want to automatically enter the number of
days in the quarter based on this value. To complicate
things even more, I need to adjust for leap years, and
would like the adjustment to be applied to as many
upcoming leap years as possible.

So, basically I want to say "If column F is 1, then column
f is 90, unless it's a leap year, in which case it is 91.
And if column E is 2, then column f is 91, and if column E
is 3 then column F is 92, and if column E is 4, then
column F is 92."

To exacerbate things, I can apparently not learn from the
Excel help guide, and I do not know much about Excel to
begin with. (For the most part, this newsgroup is my
tutorial.)

HELP! (Urgency, not random screaming!)
 
I figured out part of my problem--but still need a way to
adjust for the leap year.

I figured out the other with your help, by the way.
 
Hi
one way:
if cell E1 stores the quarter number use the following formula
=DATE(YEAR(TODAY(),E1*3+1,1)-DATE(YEAR(TODAY(),(E1-1)*3+1,1)
 
Back
Top