Question about Computers & Internet

1 Answer

Want to update the dates in excel spreadsheet

Hi:

I am trying to find a way to have the dates in a spreadsheet automatically update to show when a service call is due. Here are some dates
COMPLETE
30 DAYS
BEFORE FEB 11/08
COMPLETE
60 DAYS
BEFORE MAR 11/08
COMPLETE
90 DAYS OR MARKED

May

I want the spreadsheet to alert me when the date comes due. Can you please assist me? Thank you

Posted by on

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Sergeant:

    An expert that hasĀ over 500 points.

    Champion:

    An expert who has answered 200 questions.

  • Expert
  • 326 Answers

Try inserting seperate entry for furture day number and then reference that entry address for program math. You will have to either use same number of days to repeat (automatic) this math or accept that it would be a single shot type math. Depending on which version of excel you are using the alert can be a sound or color change. If 97 or older, there is no alert available. 2000 isn't much better.
Easier to set furture date in orginial date block right from the start. Unless you are running the excel program continuously in the background, program will only check date when running.

Good Luck,

Posted on Feb 14, 2008

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How do i fix error ox800106ba


Hi Anon,
The 0x800106ba error may occur after Windows Defender is updated due to the computer's inability to update the Windows Defender firewall. It may not have applicable permissions needed for the update, or it may not have the files necessary for updating itself.

The Fix

Set Windows Defender to Automatic - You can set the Windows Defender service to Automatic, Disabled or Manual. Setting it to automatic might solve the problem. Follow these steps:
  1. Click Start > type services in the Search box > click Services in the Programs list.
  2. If you are asked for a Password before you continue, then enter the password > click Continue.
  3. Double-click Windows Defender, and click Automatic in the start-up box > click OK.
Uninstall and reinstall Windows Defender - If the first procedure did not help resolve the problem, try un-installing and then reinstalling Windows Defender. Due to the fact that Windows Defender is a Windows component, we will use AppWiz to un-install it from the computer. Follow these steps:
  1. Press Windows Key + R > type appwiz.cpl > Press Enter
  2. Click Windows Defender > click Remove
  3. Follow the prompts to uninstall Windows Defender

Let me know how you go!

Feb 12, 2015 | Microsoft Windows Defender

1 Answer

Hi, I am trying to change an excel spreadsheet. There are unit numbers on the spreadsheet which have converted themseles to dates ie 4/52 has now become Apr-52. I have tried everythiong to change it but...


Right-click the cells and go to 'Format Cells'. Then, select the correct format. If you're wanting to leave the slash (/) in the number, you'll probably have to make it a text format.

Dec 22, 2010 | Microsoft Computers & Internet

2 Answers

How do I get the calculate button to work on my spreadsheet. My fomulas dont work or update. The spread sheet is not protected.


Normally excel should automaticallly update the values on the spreadsheet. However, in certain cases when it doesn't work, you can use the manual update key which is the "F9" key on the keyboard.

Hope this answer your question.

Jul 30, 2010 | Microsoft Excel for PC

2 Answers

Microsoft .NET Framework (KB951847) not installing


  • Hi, there are a few things you can do to see if the "Software is installed. The first is to go to the Control Panel's (Programs), Uninstall a programs, you want to view that the software is present. If the software is listed? Try to (repair, or change the program). Next, open the Task Manager from the Desktop, (right) click on the Taskbar to open. In the Task manager you want to open the Services... click on the button. In the next window, scroll through the listings to find the Microsoft. Net... click to open, and see if its (Enabled; if the service is running), if not? Enable the service, Start the service, select "Apply and OK." Note: Most changes, updates, downloads.. require the computer to be restarted for the applications to take effect. "If the solution helped?, "Ratings is appreciated, thanks"

Feb 19, 2010 | Microsoft Network Programming for .Net...

3 Answers

How do you set time and date on motorola w175g tracphone


Hi:
I have the same phone and this worked for me. I entered the menu and selected "Settings, Initial Setup, Network, Band Selection". After selecting the already checked marked"850/1900MHZ", I got a confirmation message and it then "searched for network". After the search was completed, the time date and time were reset to normal.

Jul 21, 2009 | Motorola Mobility TracFone w175 PayAsYouGo...

1 Answer

Excel Real-Time


  1. open ur spreadsheet from your files that you want to insert a dynamic date and time
  2. select the cell into which you want to insert the dynamic date and time.
  3. Type "=now()" (ignore quotation marks) into the selected cell.
  4. Press the "Enter" key on your keyboard to enter the formula into the selected cell. You will now see the current date and time appear in the cell you typed the formula into. (Date and time will update every time the "Enter" key is pressed )
.

Feb 17, 2009 | Microsoft Computers & Internet

1 Answer

Excell workbooks


You need to learn how to use the, "Paste Link," function. If you copy the spreadsheet and paste the information into a new tab in the same workbook, using the 'paste link' feature, the information on the linked pages will update automatically each time you update the page the links are based upon.

Jul 14, 2008 | Microsoft Computers & Internet

1 Answer

Automatic updates


Hi ,

right click on my computer--properties--automatic updates--click on ---check box---apply --ok
check like this..........

Jul 02, 2008 | Computers & Internet

1 Answer

Windows cannot check for updates


Backup your important info, then order your recovery disks through the manufacture and do a COMPLETE restore...

May 28, 2008 | Gateway GT5220 PC Desktop

2 Answers

Should I use countif or if or what ??


hi this my id :dadu_mf@rediff.com plz send excel material

Mar 25, 2008 | Microsoft Excel for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

93 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...