• 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

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