Year-to-date formula?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jeff (anonymous_at_discussions.microsoft.com)
Date: 03/19/04 

Date: Fri, 19 Mar 2004 10:59:36 -0800

Hi.

I'm not sure exactly what you're after, but if you
might use the following formulas:

For number of days from date in A1 from 1/1/curYR:
=A1-DATE(YEAR(NOW()),1,1)

for number of months from date in A1 from 1/1/curYR:
=(YEARFRAC(A1,DATE(YEAR(NOW()),1,1),))*12
(you can use the fraction or round or truncate it)

LOL!
>-----Original Message-----
>I found the following formula for creating a year to
date formula from
>http://www.beyondtechnology.com/tips.shtml
>
>=SUM(OFFSET(A2,0,0,1,MONTH(NOW())))
>
>My problem is that my data is not one cell per month but
is the actual
>date input in column A (my data is vertical not
horizontal)and can
>range from 3 to 9 days of inputs per month. Rather than
use the month
>function I need to use the input dates in column A. I
was considering
>an IF statement to compare A(x) to NOW() but I am have
serious brain
>drain and can't go anywhere with this. Any help would
be appreciated.
>
>
>---
>Message posted from http://www.ExcelForum.com/
>
>.
>

Relevant Pages

  • Year-to-date formula?
    ... My problem is that my data is not one cell per month but is the actual ... an IF statement to compare Ato NOWbut I am have serious brain ... drain and can't go anywhere with this. ...
    (microsoft.public.excel.misc)
  • Re: Artificial life likely in 3 to 10 years
    ... hardware - within 20 years. ... it takes a robot vision program about ... If the retina is worth 1,000 MIPS, what about the whole brain, ... how complex and completely unpredictable a single cell can be, ...
    (sci.bio.evolution)
  • Re: Brain Dead People
    ... within the individual cell, the vast amount of information that is ... factories", the total ... brain goes into dust and does not get recycled. ... designer. ...
    (talk.origins)
  • Information coding in the brain
    ... Brain Communicates in Analog and Digital Modes Simultaneously ... brain's 100 billion neurons communicate strictly by a digital code. ... contacts on their dendrites and cell bodies. ...
    (uk.philosophy.humanism)
  • Re: Big animals, big brains - big neurons or more neurons?
    ... >> does it mean proportionately more nerve cells? ... >> I ask, in part, because I seem to recall reading that the axons of neurons ... >the brain and innervates the pharynx. ... >exclusively to increases in cell size. ...
    (sci.bio.evolution)