Search:

Tag: year

Page 1 of 2 1 2

Search: Replies Views Search took 0.00 seconds.

  1. [SOLVED] Autofilling date but for 1900s

    Started by mwerner‎, 01-08-2024 08:48 AM
    autofill dates, year, year data
    • 474
    Last Post: 01-08-2024 04:17 PM
    by HansDouwe  Go to last post

    Forum:
    Excel General

  2. [SOLVED] Proforma calculation based of month and years

    Started by Shruder‎, 07-10-2023 01:09 PM
    date, month, proforma, year 6 Attachment(s)
    • 691
    Last Post: 07-24-2023 02:02 PM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  3. INDIRECT FORMULA AUTOMATE, other then just YEAR (YYYY)

    Started by StephanRS‎, 03-12-2023 10:46 AM
    automate, indirect, year 7 Attachment(s)
    • 335
    Last Post: 03-14-2023 05:25 PM
    by StephanRS  Go to last post

    Forum:
    Excel Formulas & Functions

  4. [SOLVED] Sum values from column based on multiple criteria (month & year and text)

    Started by tsprtn‎, 09-14-2022 09:26 PM
    date, month, multiple criteria, sumifs, year 3 Attachment(s)
    • 357
    Last Post: 09-15-2022 12:36 PM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  5. [SOLVED] Create Machine Utilization on a yearly calendar

    Started by Jay_Patel‎, 11-29-2021 11:55 AM
    calendar, utilisation, utilization, year 3 Attachment(s)
    • 811
    Last Post: 12-02-2021 09:38 PM
    by GeoffW283  Go to last post

    Forum:
    Excel General

  6. [SOLVED] Count Non-Blank with a Year

    Started by willhh3‎, 10-06-2021 12:41 PM
    count non-blank, year 1 Attachment(s)
    • 326
    Last Post: 10-06-2021 01:38 PM
    by FlameRetired  Go to last post

    Forum:
    Excel Formulas & Functions

  7. Reworking Gannt-chart to show years and months

    Started by Allerdrengen‎, 09-22-2021 07:00 AM
    chart, excel, gannt, month, year 6 Attachment(s)
    • 663
    Last Post: 09-23-2021 02:55 AM
    by kvsrinivasamurthy  Go to last post

    Forum:
    Excel Formulas & Functions

  8. Use SUMPRODUCT, LEFT, and YEAR functions together

    Started by excelmagic20‎, 10-22-2020 07:49 AM
    left, month, right(), sumproduct, year 1 Attachment(s)
    • 447
    Last Post: 10-22-2020 09:27 AM
    by p45cal  Go to last post

    Forum:
    Excel General

  9. Create list of 53 weeks of the UK tax year and automate their insertion as a heading

    Started by kaley99‎, 04-01-2020 09:58 PM
    automate, dates, tax, weeks, year 1 Attachment(s)
    • 702
    Last Post: 04-02-2020 12:55 PM
    by ArdusPetus  Go to last post

    Forum:
    Excel - New Users/Basics

  10. Incremental number increase with Countif and Offset when year criteria is met

    Started by MaximH‎, 01-25-2020 08:57 AM
    countif, date, offset, year 1 Attachment(s)
    • 739
    Last Post: 01-26-2020 09:08 AM
    by CARACALLA  Go to last post

    Forum:
    Excel Formulas & Functions

  11. [SOLVED] Finding Oldest Year in a series of Dates then find value in row below last day of the year

    Started by Bobbbo‎, 10-31-2019 02:45 PM
    date, last day of year, year 2 Attachment(s)
    • 687
    Last Post: 11-04-2019 04:11 AM
    by davsth  Go to last post

    Forum:
    Excel Formulas & Functions

  12. [SOLVED] excel returns serial number instead of year: "1997"=35795

    Started by rkong‎, 09-07-2019 01:21 PM
    date and range, serial number, year 6 Attachment(s)
    • 555
    Last Post: 09-07-2019 04:41 PM
    by AliGW  Go to last post

    Forum:
    Excel General

  13. [SOLVED] IF formula between dates doesn't work, returns TRUE instead of FALSE

    Started by AFGP‎, 08-21-2019 07:58 AM
    if-formula, month, year 1 Attachment(s)
    • 1,155
    Last Post: 08-21-2019 10:56 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  14. Return day number, knowing day of week, weeknum, month and year

    Started by creationracing‎, 01-07-2019 04:50 AM
    date, day, weeknum, year 1 Attachment(s)
    • 361
    Last Post: 01-07-2019 08:59 AM
    by Olly  Go to last post

    Forum:
    Excel Formulas & Functions

  15. [SOLVED] date and time format together with quarter

    Started by soreno‎, 09-20-2018 04:34 AM
    date, quarter, time, year 1 Attachment(s)
    • 553
    Last Post: 09-20-2018 07:17 AM
    by AlphaFrog  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  16. Fiscal Quarter/Year Moving Start Date

    Started by ryanwhite18‎, 07-30-2018 03:25 PM
    date, fiscal, moving, quarter, year
    • 711
    Last Post: 07-30-2018 07:02 PM
    by scottiex  Go to last post

    Forum:
    Excel Formulas & Functions

  17. [SOLVED] Calcukate no of months between dates

    Started by anilpatni1234‎, 06-18-2018 06:58 AM
    days, difference, months, year 1 Attachment(s)
    • 788
    Last Post: 06-26-2018 09:56 AM
    by JeteMc  Go to last post

    Forum:
    Excel General

  18. [SOLVED] Return blank when grabbing the year from the date in a different cell

    Started by Hedy‎, 05-08-2018 12:22 PM
    blank, formula, year
    • 512
    Last Post: 05-08-2018 03:50 PM
    by Sam Capricci  Go to last post

    Forum:
    Excel Formulas & Functions

  19. What's expiring vs current

    Started by carrieva1‎, 03-29-2018 12:41 PM
    conditional formatting, date, expire, renewal, year
    • 454
    Last Post: 03-29-2018 12:56 PM
    by 63falcondude  Go to last post

    Forum:
    Excel Formulas & Functions

  20. [SOLVED] Conditional SUMPRODUCT with blanks on different tab

    Started by wizadele14‎, 11-09-2017 07:02 AM
    blanks, month, sumproduct, value error, year 1 Attachment(s)
    • 705
    Last Post: 11-09-2017 10:53 AM
    by cbatrody  Go to last post

    Forum:
    Excel Formulas & Functions

  21. Is there any ways to randomize an entire chart with specifications?

    Started by Nightmarer26‎, 05-19-2017 07:30 AM
    chart, excel 2007, randomize, workers, year 1 Attachment(s)
    • 2,083
    Last Post: 05-25-2017 10:20 AM
    by CAntosh  Go to last post

    Forum:
    Office 365

  22. How to make year update not on January first

    Started by jackdu4‎, 05-02-2017 08:06 PM
    automate, iffunction, iffunctions, year
    • 643
    Last Post: 05-02-2017 10:25 PM
    by jackdu4  Go to last post

    Forum:
    Excel Formulas & Functions

  23. How to separate Months and Years with multiple months

    Started by jenpen77‎, 03-10-2017 01:11 PM
    formula, group, month, pivot, year
    • 513
    Last Post: 03-10-2017 01:25 PM
    by JohnTopley  Go to last post

    Forum:
    Excel Formulas & Functions

  24. [SOLVED] Converting DD/MM/YYYY to a written Month with a formula?

    Started by JackMWhit‎, 02-22-2017 07:16 AM
    dates, day, formula, month, year 1 Attachment(s)
    • 503
    Last Post: 02-22-2017 07:45 AM
    by southward  Go to last post

    Forum:
    Excel Formulas & Functions

  25. [SOLVED] Combinbing 3 If statements isn't working

    Started by Jason G‎, 11-10-2016 12:04 PM
    date, datevalue, if(), round, year
    • 583
    Last Post: 11-10-2016 02:09 PM
    by JohnTopley  Go to last post

    Forum:
    Excel Formulas & Functions

  26. [SOLVED] Seperating theresult of the Pivot table by years

    Started by artner0112‎, 03-11-2016 10:44 PM
    pivot, seperation, year 2 Attachment(s)
    • 821
    Last Post: 03-12-2016 04:11 AM
    by artner0112  Go to last post

    Forum:
    Excel Charting & Pivots

  27. Attempts to track partial years of employment; intriguing formulas, further expansion

    Started by PivotTablePSHomage‎, 01-29-2016 11:49 PM
    if function, logic, time, year, year formula
    • 1,066
    Last Post: 01-30-2016 10:28 AM
    by PivotTablePSHomage  Go to last post

    Forum:
    Excel Formulas & Functions

  28. If month and year of a date in a range of dates matches a specific date, return true

    Started by btb918‎, 10-07-2015 09:50 AM
    array, date, month, year
    • 6,742
    Last Post: 10-08-2015 01:50 PM
    by Jonmo1  Go to last post

    Forum:
    Excel Formulas & Functions

  29. If year of a date matches the year of any date in a range of dates, return true

    Started by btb918‎, 10-06-2015 05:22 PM
    dates, match, year
    • 941
    Last Post: 10-06-2015 05:30 PM
    by Tony Valko  Go to last post

    Forum:
    Excel Formulas & Functions

  30. 1905 Year vba Format

    Started by rbirch‎, 05-28-2015 04:05 PM
    date, format, year
    • 1,044
    Last Post: 05-28-2015 09:15 PM
    by Leith Ross  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  31. [SOLVED] Comparing the number "2015" to the year value of a date

    Started by Big.Moe‎, 05-05-2015 12:45 AM
    compare to number, date, year
    • 648
    Last Post: 05-05-2015 01:22 AM
    by samba_ravi  Go to last post

    Forum:
    Excel Formulas & Functions

  32. Compute formula within current year

    Started by markmkramer‎, 04-19-2015 10:58 AM
    boundary, constraint, year 5 Attachment(s)
    • 893
    Last Post: 04-20-2015 11:00 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel General

  33. trim year and default date

    Started by mtilbury‎, 03-24-2015 06:55 AM
    date, trim, vba, year
    • 679
    Last Post: 03-24-2015 07:41 AM
    by TMS  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  34. VLOOKUP MONTH & YEAR formula

    Started by ortmll‎, 01-15-2015 03:11 PM
    month, vlookup, year 2 Attachment(s)
    • 17,338
    Last Post: 01-15-2015 07:10 PM
    by FDibbins  Go to last post

    Forum:
    Excel Formulas & Functions

  35. Count number of Dates in a range that match Year and month

    Started by the_penfool‎, 01-13-2015 11:37 AM
    count, date, excel, sumproduct, year
    • 1,037
    Last Post: 01-13-2015 11:49 AM
    by Kaper  Go to last post

    Forum:
    Excel Formulas & Functions

Results 1 to 35 of 69
Page 1 of 2 1 2

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1