Calculating Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm a novice at this so please bear with me..

I need to calculate a future date

i.e. I have a patient who needs an appointment, today is 2/27/04 and the next available is 3/29/04. How can I create the three columns: today's date (to be input manually), next available appointment date (input manually) and turn-around time (calcuated by the first two columns and returned as "x days")

I'm sure this will be a breeze for all you smart folks out there! Here's hoping

Holl
 
Holly,

=DATEDIF(F3,F5,"d") & "days"
where F3 is the cell with the first date and F5 the one with the second date
Note F5 must be greate than F3!


--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

Holly said:
I'm a novice at this so please bear with me...

I need to calculate a future date:

i.e. I have a patient who needs an appointment, today is 2/27/04 and the
Click to expand...
next available is 3/29/04. How can I create the three columns: today's date
(to be input manually), next available appointment date (input manually) and
turn-around time (calcuated by the first two columns and returned as "x
days")?
 
Hi

With today's date p.e. in cell A2, and next appointment in cell B2:
=B2-A2
and format as number


--
(Don't use my reply address - it's spam-trap)

Arvi Laanemets


Holly said:
I'm a novice at this so please bear with me...

I need to calculate a future date:

i.e. I have a patient who needs an appointment, today is 2/27/04 and the
Click to expand...
next available is 3/29/04. How can I create the three columns: today's date
(to be input manually), next available appointment date (input manually) and
turn-around time (calcuated by the first two columns and returned as "x
days")?
 
Holly,

You could also use

=F5-F3 & " days"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Oops, that's so basic.

Why the ?&*% didn't I think of just that.

Ah well, why make thing simple if it can be done in a more difficult way :)
..


--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Back
Top