How can I use dates in a formula?

S

signal

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I want to grab todays date in an excel formula, and subtract it from another date.

For example, our quarter ends on march 31, 2010. I want to figure out the number of days left in the quarter. What would even be cooler is to only factor in work days.........anyone know how to do this?
 
B

Bob Greenblatt

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
I want to grab todays date in an excel formula, and subtract it from another
date.

For example, our quarter ends on march 31, 2010. I want to figure out the
number of days left in the quarter. What would even be cooler is to only
factor in work days.........anyone know how to do this?
Click to expand...
To find the difference in days between 2 dates, simply subtract them. If you
are only interested in work days search Excel help for workday
 

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

subtraction formula 4
Automatic Cell fill 7
Fractions 1
how do I create formula for if a valuegreater that zero is added it shades another cell? 1
Formula Question 3
Switching axis of a chart 4
Excel opens a long list (13+) of worksheetsthat are saved on one of my iMacs 1
Excel Charts 1

Top