date and future

  1. S

    Today's Date Conditional Formatting

    I am using Excel 2007. There is a lot on the forum concerning dates and conditional formatting, but I haven't figured it out for this yet. Please help. I have two columns of dates. The first column (E) is the date I perform the task. The second column (F) is the date the task is next due...
  2. A

    Hiding a group of cells by condition

    Hi.. I am an absolute newbie in this setting and would appreciate some help. Is there a way by which you can hide a group of cells in an excel sheet by condition?? What I was trying to do was to a) label rows according to date. b) create a condition to hide the rows once the date has passed...
  3. A

    Date Help

    I need to calulate the Date based on Given the following information. Thursday 17/12/2009 then friday week 25/12/2009 then sunday week.. and so on. I will be used calculate a promotional time table and need to be accurate. It has been explained to me that, to make the promotion FAIR to...
  4. M

    If, VLookUp, and date. Future date Lookup problem.

    Goal: if today is greater than last day of month, if true then last result of month, if false: lookup yesterday in range $E$62:$AK$645, column 2. This is the formula: =IF(TODAY()>$E$643,F$643,VLOOKUP($BK$1,$E$62:$AK$645,2)) Col E= all dates of the year. $E$643 is the 31st December. Col F=...

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