=if(day(k3)<16,a25-1,"")
"coal_miner" wrote in message
...
I need an if formula that takes a date in cell K3 and determines if the
month
in that cell is halfway over. If it is not halfway over, then it
subtracts
the number 1 from cell A25. If the month is halfway over, then do
nothing.
Is this possible, and if so, please let me know. Much obliged.
|