How do I use "if statements" when working with dates?

[Guest]

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.

 

[Don Guillett]

will this work?
=DATE(YEAR(G3),MONTH(G3)+IF(DAY(G3)<10,0,1),10)

 

[T. Valko]

Try this:

=DATE(YEAR(TODAY()),MONTH(TODAY())+(DAY(TODAY())>10),10)

 

[T. Valko]

Hmmm...

=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.