Home » Forums » Open Source Learning Center » Learning requests

Help new to Excel

Submitted by MJS on 2 December, 2009 - 17:28

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

‹ User Form - Copy Paste into text box VBA Program learn ›
»
Nick's picture

Today

Submitted by Nick on 3 December, 2009 - 12:40.

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

Submitted by MJS on 8 December, 2009 - 17:22.

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

Submitted by Nick on 8 December, 2009 - 17:40.

ok, well my suggestion above should work.

»

Is there a formal that can

Submitted by MJS on 3 January, 2010 - 13:52.

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

Submitted by Nick on 4 January, 2010 - 11:58.

you can add a zip file to your original post.

click on it and edit

»

What about this one

Submitted by Cyril Myshkin on 3 January, 2010 - 20:43.

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

»

Shorter one

Submitted by Cyril Myshkin on 3 January, 2010 - 20:47.

 =TEXT(TODAY();"MMMM")

»