• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Present date, calculate dates left from column "B" and show on column "G"

K

kalua1231

Member
Hello Chandoo ninjas, looking for a way to have present date calculate dates on column "B" and show how many days are left in column "G". Thank you guys for your help and time.
 

Attachments

  • Date Generator.png
    Date Generator.png
    107.7 KB · Views: 0
  • BK TO DO LIST.xlsm
    241.2 KB · Views: 0
Hey guys, just letting everyone know i know that this code works.

=IF(B6<>"",B6-TODAY(),"")

But what i am looking for, is a code where i can paste it on the main page.
 
***(Example) on row, column "B" = 10/4/16 on column "I" it will = 5)
***(Example) on row, column "B" = 10/9/16 on column "I" it will = 10)
***(Example) on row, column "B" = 11/4/16 on column "I" it will =36 )

Hope this is clear friend.
 
You must log in or register to reply here.
Back
Top