=IF(DAY(NOW())<21, FORMULA 1, FORMULA 2)

V

Van T. Dinh

You're welcome.

As you can see, my suggestion was correct right at the beginning and you
would have got this working had you read my reply properly. Please read
replies carefully and thoroughly in the future.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query to Complex with Criteria 1
Between 21st last month to 21st this month 4
Complicated Date Calculation needed 5
Date Serial Problem 2
Storing a date in UK format 17
John W. Vinson...continued help please 4
IIF with Dateserial and Between 2
Last day of this Month 4

Top