Excel Bods: Help Needed - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HUKD, you accept our cookie and privacy policy.
Get the HUKD app free at Google Play

Excel Bods: Help Needed

Disco Avatar
7y, 2m agoPosted 7 years, 2 months ago
I need a formula which will display days remaining in say, Cell A2 when a date is inserted in A1

thanks in advance.

Disco Avatar
7y, 2m agoPosted 7 years, 2 months ago

All Comments

(4) Jump to unreadPost a comment
days remaining? wouldnt it be (days variable) - A1?
days remaining? wouldnt it be (days variable) - A1?

its for a friend wedding... date is april 11th 2010. shes using a budget planner in excel, so want it to display the number of days left to SAID DATE everytime she opens the excel file :thumbsup:
suspended 2 Likes #3
Ok here is how to do that:

Make 2 seperate cells, such as A1 and A2. Right click and format these cells to dates *../../....
then enter for one of the cells, =TODAY()
The above will put the code for the current date of viewing the document
for the next cell type the date you wish to countdown to (make sure that they are in the same format)

Then make a new cell, E.g. A3, and copy and paste this formula ,

="There are "&INT(A2-A1)&" days until the wedding"

*A1 being today's date

That works when i just done it on my laptop, so it should work for you
cheers - worked a treat

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!