previous month

  1. C

    VBA Save as on desktop with previous month's first and last dates

    Hi, Still beginner here. I've been trying to find the way with Google, but there are too many different response and none have worked for me so far. I need to save a file with this name(based on today being August 2022) to my desktop: "2022-07-01 to 2022-07-31 Consolidated file.xlsx" "The first...
  2. F

    Look up values of month from previous year

    Hi, I need to write a function, which find value from month from previous year: Below is example of my data (I have year starting from 1992 - but it should not have meaning) <tbody> Year Month Quater RepQua ID Value PrevValue 2015 Jan Q1 FY15Q1 A1B 10 - 2015 Apr Q2 FY15Q2 B2C 20% -...
    • Forestq
    • Thread
    • previous previous date previous month vlook up vlookup
    • Replies: 9
    • Forum: Excel Questions
  3. S

    Previous month, based on user defining current month

    To get straight to the point, a user enters a month either January, February and so on. The formula needs to calculate the previous month. Thus if the user enters "March", the formula will return February. all the user will enter is a month not a date.:biggrin: Thanks, I know this is...

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