Hmmm...

if the day of the current date is 10th
=DATE(YEAR(TODAY()),MONTH(TODAY())+(DAY(TODAY()) 10),10)

Hold on there just a second. Are you sure this is what you want? I think you
need a *static* "current date" to use as the comparison. Otherwise, the
formula I suggested will return a different result every 11th of the month.

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Try this:

=DATE(YEAR(TODAY()),MONTH(TODAY())+(DAY(TODAY())1 0),10)

--
Biff
Microsoft Excel MVP


"Statesman" wrote in message
...
I need...formula if the day of the current date is 10th, then due date
will
be 10th of following month. Otherwise, due date will be 10th of current
month.