1/0/1900

  1. O

    Cant update date of 1/0/1900

    New To Mr Excel. I need to add a formula that will auto enter the date and time any entry is made in the adjacent cell and keep it there regardless of how many times that sheet is accessed. I need it to capture the date and time of the entry and not change. When I use a formula like this...
  2. S

    Evaluate column and replace existing values

    Hi, I am trying to have a macro evaluate column D which has dates listed, however, several in which are 1/0/1900 which I want to replace with nothing. Does anyone have any suggestions?
  3. V

    If not found , set a specific answer instead of 1/0/1900

    Hello ! I have a following formula here. I am trying to keep track of the latest transaction made. This is an Array Formula entered with Control+Shift+Enter. =MAX(IF($B$1:$B$4=$A8,IF($C$1:$C$4="Cu",$A$1:$A$4))) =MAX(IF($B$1:$B$4=$A8,IF($C$1:$C$4="Dp",$A$1:$A$4))) <tbody> A B C 1...
  4. E

    Trouble combining If(Countif & Vlookup criteria to omit 1/0/1900 values

    Hello. I am using Windows 7 and Excel 2007. I want to see results if the alpha-numeric value of column B appears in column A of Sheet3. The result I am looking for is a date value from Sheet3 listed in column W corresponding to the row matching the value in the current sheet's column B. If...
    • eNovice22
    • Thread
    • 1/0/1900 countif and excel formula if(countif if(len(vlookup vlookup 2 conditions
    • Replies: 3
    • Forum: Excel Questions
  5. C

    1/0/1900 Problems...

    As I am new to the forum I am hoping that someone might be able to give me some assistance. I am not an Excel "expert" and know enough to get me in trouble. I am working on a spread sheet and have come up with the following formula that works for what I need it to do, but the formula displays...

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