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

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit
Expired

Excel Bods: Help Needed

£0.00 @
I need a formula which will display days remaining in say, Cell A2 when a date is inserted in A1 thanks in advance. Disco Read More
Disco Avatar
7y, 8m agoPosted 7 years, 8 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
Disco Avatar
7y, 8m agoPosted 7 years, 8 months ago
Options

All Comments

(4) Jump to unreadPost a comment
Comments/page:
#1
days remaining? wouldnt it be (days variable) - A1?
#2
munaaf
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
#4
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!