todays date

  1. W

    VBA macro button to select todays date changes formatting???

    Hello I hope somebody can shed some light for me. I have a macro button on my s/sheet that runs pretty well to highlight todays date within a row. However it also red borders the left and right side of the column below and im not sure why? It is quite useful and I would like to have the same...
  2. A

    I need to insert the current date into a specific cell using vba... Please see contents for more details.

    Good Afternoon All, I have Excel 2013, Windows 7 Professional... I currently have the code below, and would like to change the line just above "End Sub" that contains "ActiveWorkbook.Sheets("Sheet1").range("D3") = dateString" so that it puts in the current date into that cell. I just started...
  3. M

    Calculating Networkdays, but when blank cell use todays date

    I am trying to calculate the networkdays that documents are open. I have three columns "Date Opened" "Date Closed" and "Days Open" sometimes the date closed is blank so days open returns blank using: =IF(I40<>"",NETWORKDAYS(H40,I40),"") BUT I'm trying to chance it to if its blank it will...
  4. 1

    If Then Using Todays Date +/- 30 Days

    Hi - I am trying to create a formula that states the following: If date in cell K3 is less than 30 days from today's date (I can put today's date in cell A3 if needed), then cell M3 = Yes I cannot figure this one out... can anyone help? :confused: THANK YOU!!!! :)
  5. N

    Using a hyperlink to place Todays Date in an adjacent cell

    Hello, I am trying to make a series of checklists for fall/spring or other activities that would allow someone to click a hyper-link ( name of link will read "Done") and see Todays Date in the adjoing cell to the right, ( to indicate the date chore was accomplished). I have only very basic...

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