excel date calculations

  1. P

    Excel formula for date

    Hello, can anyone help me with excel formula for the column Month before year start, Duration (months), Month after year end and Months in 21/22 below please :- FY 21/22 Year Start: 01/08/2021 Year End: 01/08/2022 Project Project Dates Start Month before year start Project Dates...
  2. P

    Date formula

    Hi, I am struggling a bit to get my date formulas working. In a sense it is a 2 pt question. I basically have a date of which I need to add X amount of days which may go into into the next month at times. Then if that target date after getting added x days is a weekend or holiday it needs to go...
    • Pv488
    • Thread
    • excel date calculations excel date formula excel dates excel formula 2013 excel formula help
    • Replies: 8
    • Forum: Excel Questions
  3. R

    ***robotics date macro - 1***

    Hi, I need a macro/vba code which can calculate the Age calculation. I mean it must calculate current date minus the different pay date in column d to column c. As i have to do it manaually on daily basis so i want to do it automatically the moment i paste the new pay dates in column d. Please...
    • rohitw2
    • Thread
    • age calculator date and day excel & vba excel & vba 2010 excel date calculations
    • Replies: 9
    • Forum: Excel Questions
  4. W

    Date Format

    I am scraping data from a flight planning website that brings a date value into a cell like this: "Tue. 7/26". Currently I have the formula "=RIGHT(X42,2)" to extract the day and "=MID(X42,6,1)" to extract the month. This formula doesn't work all of the time depending on whether or not the...
    • wid2001
    • Thread
    • date & time format excel date calculations vba vba & excel
    • Replies: 2
    • Forum: Excel Questions

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