today() with if condition

  1. A

    Display cell value a1 if b1 is today()

    Looking for formula, where it checks cell b1 for today's date, then Display cell value a1 in cell c1. Note: b1 format is (3/10/2022 10:06)
  2. A

    today() + if Condition

    Respected Mate, A1 n B1 are Start Date n End date of a schedule, which are blank right now, waiting for an input to be entered in C1, when I type "WIP" in cell C1, then it should start a schedule from today in cell A1 / Start Date, =if(C1="WIP",today(),"") ...right it happens this way only...
    • amulay
    • Thread
    • cell date start today today() with if condition
    • Replies: 2
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top