Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Spreadsheet to calculate days left

  • 06-06-2008 11:12PM
    #1
    culabula88
    Closed Accounts Posts: 401 ✭✭


    i want to set up a spreadsheet where i am putting different dates in one column and then in the next column it will show me how many days are left to that deadline.


Comments

  • #2
    Kane
    Registered Users, Registered Users 2 Posts: 37 ✭Kane


    culabula88 wrote: »
    i want to set up a spreadsheet where i am putting different dates in one column and then in the next column it will show me how many days are left to that deadline.

    Here is how you would do it in Excel:

    -> Enter todays date in one cell (say D1)
    -> You can either type this in or use "=TODAY()" (Don't type in quotes!!)
    -> If Column A is the deadline dates and you want Column B to be Days left then the formula (say for Cell B2) would be "=A2-$D$1"
    -> This is just Deadline date (A2) minus Todays Date ($D$2). I have made todays date absolute by putting dollar signs around it so that you can copy it down and the reference stays the same.
    -> Make sure to change the format of Column B to General (By choosing Format Menu and Cells sub-menu).

    I hope this helps.


  • #3
    culabula88
    Closed Accounts Posts: 401 ✭✭culabula88


    I have some of the deadline dates typed in as 19th June etc. is there any way I can change these to 19/06/2008 format in order to use the formulas as outlined by you above.


Advertisement