+ Reply to Thread
Results 1 to 2 of 2

Need a server reboot schedule that uses date entered column, days up column and days left

  1. #1
    Registered User
    Join Date
    09-03-2019
    Location
    Atlanta, GA
    MS-Off Ver
    365
    Posts
    3

    Need a server reboot schedule that uses date entered column, days up column and days left

    I need a column called "Date Uptime Entered" where I will manually enter this date with no formula. Then I need a column called "Days Up" where I will manually enter how many days the server has been up with no formula. The next column I need called "Days Until Reboot" will calculate how many days left until a reboot is needed based on 1 every 365 days. I need this column to automatically calculate this based on the date the uptime was entered and how many days up it has been. So tomorrow the "Days until reboot" will automatically be 1 day less. If the "Days Up" is greater than 365 then I need this to show as a negative and continue counting. Thanks in advance for your help.

  2. #2
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,832

    Re: Need a server reboot schedule that uses date entered column, days up column and days l

    Well, not sure I understand completely, but maybe try this:
    Date Uptime Entered is in cell A2 and Days up is in B2
    =365-(TODAY()-A2+B2)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Automatically generate date 90 days from adjacent column date entered
    By louhazosc in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-31-2021, 09:51 AM
  2. Need countdown formula for days left until server needs reboot
    By ServerGuy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-03-2019, 04:31 PM
  3. [SOLVED] matching error between column having every date and column having business days
    By jrtaylor in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-17-2017, 01:58 PM
  4. Replies: 3
    Last Post: 04-08-2016, 09:11 AM
  5. Add Date in Column A Plus Number of Days in Column B and show result in Column C
    By excelforumcrisis in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-12-2013, 02:01 PM
  6. [SOLVED] Search 1st Column for Date older than 5 days based on 2nd column contents
    By Nu2Java in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-31-2012, 10:49 PM
  7. Replies: 3
    Last Post: 08-22-2006, 04:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1