Tech Support Guy banner
Status
Not open for further replies.
1 - 3 of 3 Posts

·
Registered
Joined
·
1 Posts
Discussion Starter · #1 ·
Need help setting up a date formula in Excel '97.

Have first date of today, have second date of next available appointment. Need Excel to formuate the turn-around time (i.e. today 4/6/04, next appt date 5/5/04 = 29 days.

How do I do this??? It's driving me crazy. It's probably something quite simply that I'm not think of!

Thanks!

Holly
[email protected]
 

·
Registered
Joined
·
331 Posts
In addition to the Datedif function provided by Phil, you can format the cell that houses the formula as General and use,

=B1-A1&" days"

where B1 is the end date and A1 is the start date.
 
1 - 3 of 3 Posts
Status
Not open for further replies.
Top