Dates

S

sdmccabe

Could you please suggest a formula to compare the contents of two cells
containing date values and display the difference in days?
 
J

JE McGimpsey

One way:

A1: <date1>
A2: <date2>
A3: =A2-A1

Format A3 as General or another Number format.

this works since XL stores dates as integer offsets from a base date.
 
W

widman

You can also then use conditional formatting to A3 to change color if it is
within or outside of ranges you choose.
 
Top