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

S

Statesman

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

T. Valko

Hmmm...
=DATE(YEAR(TODAY()),MONTH(TODAY())+(DAY(TODAY())>10),10)
Click to expand...

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