date autodate

  1. apgmin

    date auto populate

    Hello, Please help me In cell A1 ; I have a date that is to be filled In cell B1 ; I need the date to be 12 days after the date filed in A1 BUT such that if the end result is saturday or sunday, then it will add 1 or 2 days so that the end result is a monday If the end result in Cell B1 is a...
  2. T

    Auto Rolling YTD number vs. previous YTD number& Current Month to Date vs. Previous Year MTD

    I need to create a comparison of MTD, YTD, and a 3 month Comparison in Excel 2007 using the current date (mm). I do not want to have to change a number to signify the month. The Data is laid out like this: <TABLE style="WIDTH: 480pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0...
  3. D

    Date Change Only When New Data Is Entered

    I'm sure this has been asked a million times but I am in a time crush and have to figure this out ASAP! This board has been a great help in stumbling my way through Excel so I hope that someone can help me out with this conundrum! I have a spreadsheet that we use to keep track of quotes from...
  4. A

    auto date input?

    Hi, can i make excel automatically date the squares, like, 1/1/2000 in a1, 2/1/2000 in a2, 3/1/2000 in a3 and so on.. i thought it'd be pretty simple, apparently not.. can you guys help? thanks :)

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