Posted by: tonyteaching | April 2, 2009

Ms. Excel 2007: Subtracting Date

I want to subtract dates, for example 8/10/2009  (in cell A2) – 5/10/2009 (in Cell A1) then I got 3 days as result=

Simply just

=A2-A1

but make sure the cell format is general


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Categories

%d bloggers like this: