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
ExcelExperts.comExcel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 |
|
Excel / VBA ConsultancyFree Training VideosFree SpreadsheetsExcel / VBA JobsNavigationWho's onlineThere are currently 0 users and 478 guests online.
New Excel Experts
Current Excel / VBA Jobs |
Help new to ExcelHi 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 |
Highest Ranked Users
Recent Blogs
ForumsRecent comments
User login |
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.
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.
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")