View original (French)

Excel: if I want to return yesterday's date

Solved
chamel_éon -  
 chamel_eon -
Bonjour,

I have a problem, I want to return yesterday's date if I check my Excel sheet between 00:00 and 1:00. I started with the formula IF(COUNTIF(NOW(); "00:**); I am looking for what to enter; TODAY()).

Can you help me?

Configuration: Windows 7 / Chrome 46.0.2490.86

1 answer

  1.
    via55 Posted messages 14393 Registration date   Status Member Last intervention   2 759
     
    Hello

    Try instead:
    =IF(HOUR(NOW())=0;TODAY()-1;TODAY())

    Best regards
    Via

    --
    "Imagination is more important than knowledge." A. Einstein
    0
    1. chamel_eon
       
      Thank you very much, it worked well.
      0