todays

  1. K

    If function help

    I am not sure if this is possible or not but I am trying to write an if condition for a sum on a spreadsheet that if it doesn't meet the criteria that it doesn't calculate and leaves the previous value This is my if statement =IF(A1="final",SUM('Post 9-30am payments'!B1+'Post 9-30am...
  2. B

    Msgbox if todays date is less than date in range??

    Can someone help please? I have a range of cells (B2-E10) which have a number of important dates I require to track. Can I code that when I open the workbook if todays date is less than or equal to the 5 dates leading up to any of the important dates a msgbox will appear? Any help appreciated.
  3. K

    Macro Script needed

    hi all , I have a column AI in which dates are given in (MM/DD/YYYY) I am looking for a macro which selects all the dates in Column AI apart from today's date . If anyone can help !!!
  4. A

    VBA to protect cells before today's date

    Hello, I have a spreadsheet with row wise dates in column A. I need a vba code to automatically protect cells with password from column A to J (row wise) when Today's date is passed. Could anyone help me with a code? The code should not start with Sub "Private Sub Worksheet_Change" as I already...
  5. E

    Clear contents of specific rows given criteria

    Hey all, Love this place of wisdom! May I please have a macro button on the same sheet that says: If start date in cells D10:D100 has passed today's date and end date in cells E10:E100 has also passed today's date, delete values in B10:E100 and G10:I100, then sort column D10:D100 by oldest to...
  6. T

    Is there macro that can scroll to a date in a column?

    Hi Everyone, I have a sheet with this years calendar in it (so you can imagine it 365 columns wide I row1 I have the dates Start In Column G with 01/01/2017 and go up one day at a time across the page to give me my calendar in A2 in Have todays date hat Id like is a macro that when I select...
  7. M

    Formula to calculate working days date.

    Hi Forum, I am trying to create a formula which will calculate the working days date. If column A is having today's date and yesterday's date then result should be same and If column A is having prior to yesterday's date it should show today's date. Below formula is working correct with weekdays...

Watch MrExcel Video

This Week's Hot Topics

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
Top