Creating dates using IF formula
 

Excel can calculate dates.

It's not clear, though, from your description what you need to do. Please
provide more details about how you want to calculate dates, and someone will
come up with a solution. There are simply too many methods to date
calculation in Excel to reliably respond to your post with the information
provided.

Dave
--
Brevity is the soul of wit.


"laura" wrote:

I am working on a project that requires that I calculate dates. The problem
is that the formula must calculate specific dates (1/1 and 7/1) with the
correct year. Can anyone tell me the best way to handle this other than
using another program?

Thanks!