Help new to Excel

Hi Just found your very helpful website and wondered if you could help me, I am trying to get a spread sheet to reset its self when the date changes to a new day ( a row of 1 to be reset to 0).

 

Martin

Nick's picture

Today

hi Martin

This question doesn't make much sense.

What are you actually trying to do ?

... you could try using the formula:

=if(TODAY()>Date(2009,12,2),0,1)

where Date(2009,12,2) is the date you want to compare today's date to.

I will try to explain myself

I will try to explain myself more clearly. I have a page that has 30 rows and 2  columns, column A names and column B a number, I am trying to return column B after 24 hrs to return to 0 atomically.

Nick's picture

changing values based on the day

ok, well my suggestion above should work.

Is there a formal that can

Is there a formal that can put data into a month say January and at the end of January change to the next month.

How do you add a zip file to a posting.

Nick's picture

Zip file

you can add a zip file to your original post.

click on it and edit

What about this one

 =CHOOSE(MOUNTH(TODAY()),"January","Febrary","March","April","May","June","July","August","September","October","November","December")

Shorter one

 =TEXT(TODAY();"MMMM")