how do i put formula to find difference between two dates

M

Max

Re: how do i put formula to find difference between two dates

Put in C1: =B1-A1

where
A1 contains the start date, say: 01-May-2005
B1contains the end date, say: 10-May-2005

For the sample dates in A1 and B1, C1 will return: 9
 
M

Max

Bob Umlas said:
Format the answer as General.
Click to expand...

Thanks for the add-on, Bob !

I must have done up the formula in C1 first,
followed by the test date inputs in A1 and B1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting the difference between a "negative" number and a positive 2
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Help with determining # of days from certain dates 2
Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1
Show value from one cell in another cell if today falls between a date range 5
somewhat complicated conditional formula 2
IF AND Function Date Range Issues 6

Top