I want to input data from cell D5 twice each calendar month. I’ve tried various ways but cannot get it to work.
for example: =IF(OR(DAY(A399)=24, A399=7), D$5,0) enters data on the 24th each month but not the 7th. Where am I going wrong.
Ive tried playing around “if and” statements also but no joy.