Date Different

Do you know that you can actually use Excel to calculate different between 2 date values? Also use Excel to easily find 100 days after a certain date.

Example 1 – Different between two dates

A1 = 2017-01-01
B1 = 2017-03-01
C1 = B1-A1
   = 59 days

Example 2 – When is after 100 days?

A1 = 2017-01-01
B1 = 100
C1 = A1+B1
   = 2017-04-11
Advertisements

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