View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mjones mjones is offline
external usenet poster
 
Posts: 86
Default Conditional Format - If day = 24 or 25

On Jan 25, 8:41*pm, Pete_UK wrote:
In that case you would use this formula:

=OR(DAY(TODAY())=24,DAY(TODAY())=25)

Hope this helps.

Pete

On Jan 26, 1:27*am, mjones wrote:



Thanks for replying. *I need to clarify though.


I meant the actual day, like today() knows the actual date. *The date
is not in a cell.


Is this still possible?


Great. Thanks!!!!