Combining 2 IF statements to make one formula.

R

Rip1877

I need to combine the following 2 IF statements, or find a different formula
to make this happen.

=IF($K$6="","",$K$6+14)

=EOMONTH(K6,0)

K6 is the starting date of a payperiod, so the first formula goes to the
15th of the month. The second formula is needed if the start of the payperiod
is the 16th.
 
E

Elkar

See if this is what you're looking for:

=IF($K$6="","",IF(DAY($K$6)=1,$K$6+14,DATE(YEAR($K$6),MONTH($K$6)+1,0)))

HTH,
Elkar
 
Top