Hi,
I have a sheet with an available date in column c, in column d i want to give a "days to available" figure.
I want this to work it from todays date, and when i open it up tomorrow, tomorrows date.
If that makes sense?
Any help greatly appreciated
Joe
Hi Joe
Do you mean that you need in this column to see the available days, IF These days are equal to Today?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Hi there,
IF availability in a cell = 23/06/12 and today is 24/06/12 i want the cell next to 23/06/12 to show a 1 as its 1 day to availability
Cheers
Just deduct the date from the available date. Format as dd
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
=TODAY()-A1
As i understand it....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks