Search:

Tag: date and range

Page 1 of 2 1 2

Search: Replies Views Search took 0.00 seconds.

  1. [SOLVED] Calculating scheduled hours per resource between 2 sets of overlapping date ranges

    Started by Joseph1058‎, 03-11-2025 01:41 PM
    date and range, hours calculation, hours worked, schedule comparison, workdays 2 Attachment(s)
    • 196
    Last Post: 03-12-2025 10:16 AM
    by windknife  Go to last post

    Forum:
    Excel Formulas & Functions

  2. Date Picker

    Started by krizcola‎, 09-05-2024 04:04 PM
    date, date and range, macro (vba) 2 Attachment(s)
    • 475
    Last Post: 09-24-2024 10:14 AM
    by torachan  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  3. Insert current date into cell based on another cell true / false across workbook sheets

    Started by CG1990‎, 05-10-2023 05:37 PM
    date and range, search a range, urgent help needed, vba & macro, worksheets loop
    • 426
    Last Post: 05-10-2023 10:08 PM
    by CG1990  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  4. VBA to check between two dates, compare with today and if true then copy entire data

    Started by Vacheron23‎, 10-15-2022 03:55 AM
    date and range, today date 2 Attachment(s)
    • 419
    Last Post: 10-17-2022 02:18 AM
    by Sintek  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  5. [SOLVED] mark special date and time period in Excel worksheet

    Started by Jeremiuh‎, 10-07-2022 02:42 PM
    date and range, rules 6 Attachment(s)
    • 497
    Last Post: 10-08-2022 03:39 AM
    by Kaper  Go to last post

    Forum:
    Excel Formulas & Functions

  6. Adding multiple date ranges.

    Started by Viswa88‎, 03-25-2022 11:33 PM
    date & time calculation, date and range 1 Attachment(s)
    • 524
    Last Post: 03-26-2022 04:20 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  7. Extract and return a Min date and Max dates.

    Started by Mohammad Munawar‎, 03-17-2022 07:05 AM
    date and range, max, min 5 Attachment(s)
    • 697
    Last Post: 03-17-2022 01:40 PM
    by FlameRetired  Go to last post

    Forum:
    Excel Formulas & Functions

  8. [SOLVED] Conditional Formatting to highlight overlapping dates on Vacation roster

    Started by JeremyJ‎, 01-31-2022 02:20 PM
    conditional formatiing, date and range, overlapping dates 2 Attachment(s)
    • 610
    Last Post: 02-01-2022 04:33 PM
    by janmorris  Go to last post

    Forum:
    Excel Formulas & Functions

  9. Splitting a period of time into days in the relevant months

    Started by Lars-Denmark‎, 11-10-2021 09:14 AM
    date and range 3 Attachment(s)
    • 492
    Last Post: 11-10-2021 01:13 PM
    by bsalv  Go to last post

    Forum:
    Excel Formulas & Functions

  10. [SOLVED] Create conditional formatting to help with payment dates

    Started by JStroger‎, 10-08-2021 02:24 PM
    conditional formatting, date & text formula, date & time calculation, date and between, date and range
    • 428
    Last Post: 10-08-2021 02:29 PM
    by JohnTopley  Go to last post

    Forum:
    Excel Formulas & Functions

  11. Two Date Range Lookup based on Index Formula

    Started by mannyz8‎, 08-20-2021 01:43 PM
    date and between, date and lookup, date and range, index & aggregate
    • 411
    Last Post: 08-21-2021 02:10 AM
    by Pepe Le Mokko  Go to last post

    Forum:
    Excel Formulas & Functions

  12. [SOLVED] Add values based on specific dates

    Started by birdmannn‎, 05-29-2021 02:25 PM
    date & value, date and range, dates beginning period, dates difference, dates formula 2 Attachment(s)
    • 602
    Last Post: 05-29-2021 03:49 PM
    by birdmannn  Go to last post

    Forum:
    Excel General

  13. [SOLVED] VBA to count "[specific text]" after defined date in adjacent column

    Started by lilybickel‎, 03-19-2021 11:44 AM
    count, date & text formula, date and range, udf, vba 1 Attachment(s)
    • 531
    Last Post: 03-22-2021 07:51 AM
    by lilybickel  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  14. Finding Number of Days from Previous Date

    Started by anonymous321‎, 11-23-2020 02:31 PM
    date & time calculation, date and range, excel 2 Attachment(s)
    • 496
    Last Post: 11-23-2020 03:33 PM
    by anonymous321  Go to last post

    Forum:
    Excel General

  15. Multiple Months and Figuring Numbers

    Started by Darkcloud617‎, 11-12-2020 12:48 PM
    data anaylsis, date and range, pivot 5 Attachment(s)
    • 825
    Last Post: 11-17-2020 11:46 AM
    by AliGW  Go to last post

    Forum:
    Excel General

  16. Return Specific Date When it Falls Within a Date Range

    Started by pbf29078‎, 08-07-2020 12:00 PM
    date and between, date and range
    • 1,762
    Last Post: 08-08-2020 12:54 PM
    by Dante Amor  Go to last post

    Forum:
    Excel General

  17. If two sets of dates fall within another two set of dates

    Started by svundemo‎, 03-30-2020 12:26 PM
    date and between, date and range, multiple date range, two dates 3 Attachment(s)
    • 650
    Last Post: 04-04-2020 02:36 AM
    by etaf  Go to last post

    Forum:
    Excel Formulas & Functions

  18. [SOLVED] Formula to return value based on date range table

    Started by lucasc10‎, 03-30-2020 10:05 AM
    date, date and between, date and range, formula 1 Attachment(s)
    • 1,863
    Last Post: 03-30-2020 10:35 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  19. Calculating start based based on input of another start date and academic year

    Started by emmab07‎, 09-21-2019 11:15 AM
    date & text formula, date and between, date and range, date and time auto fill 2 Attachment(s)
    • 676
    Last Post: 01-11-2020 02:38 PM
    by Bo_Ry  Go to last post

    Forum:
    Excel Formulas & Functions

  20. [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)
    • 732
    Last Post: 09-07-2019 04:41 PM
    by AliGW  Go to last post

    Forum:
    Excel General

  21. Copying and inserting data from one worksheet to another based on Date Range

    Started by DuaneCunnington‎, 05-15-2019 09:36 AM
    date and range, macro (vba), vba & excel 1 Attachment(s)
    • 553
    Last Post: 05-15-2019 09:12 PM
    by DuaneCunnington  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  22. [SOLVED] Count nr of dates in a range without duplicates

    Started by Faustocruz‎, 05-09-2019 06:46 AM
    countif, date and range, no duplicates 1 Attachment(s)
    • 1,815
    Last Post: 05-09-2019 07:39 PM
    by GeoffW283  Go to last post

    Forum:
    Excel General

  23. Need help setting up a FIFO metric in excel

    Started by JaySyph‎, 05-06-2019 01:00 PM
    date and range, formula assistence, percentage, pivot table
    • 544
    Last Post: 05-08-2019 06:04 AM
    by Kaper  Go to last post

    Forum:
    Hello..Introduce yourself

  24. Extract date range from cell and populate 'calendar-style' in separate tab

    Started by ammegrace‎, 01-19-2019 08:25 PM
    date and range 4 Attachment(s)
    • 1,900
    Last Post: 01-20-2019 06:28 PM
    by Pete_UK  Go to last post

    Forum:
    Excel General

  25. Copy formulas from one column to next column based on Current & Prior Month

    Started by balston2‎, 11-29-2018 05:26 PM
    date and range, date function, vba
    • 580
    Last Post: 11-29-2018 08:59 PM
    by AlphaFrog  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  26. Sumproduct Date Compare for Month and Year

    Started by missdeannamarie‎, 11-01-2018 07:32 PM
    date and range, sumproduct calculation, sumproduct date compare 1 Attachment(s)
    • 509
    Last Post: 11-08-2018 04:13 PM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  27. Highlight Cell if date range is within today

    Started by Noahtea‎, 09-04-2018 06:39 PM
    date and range, format condition, highlight 1 Attachment(s)
    • 741
    Last Post: 09-04-2018 09:59 PM
    by gak67  Go to last post

    Forum:
    Excel Formulas & Functions

  28. Macro to search/filter raw data within date range

    Started by iqbal.88‎, 05-16-2018 07:07 AM
    date and range, filter, vba & excel 5 Attachment(s)
    • 771
    Last Post: 05-17-2018 10:47 AM
    by Marc L  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  29. Counting Number of Times Dates Appear In Excel Cell within Month/15DAYS/7DAYS

    Started by anonymous321‎, 03-03-2018 06:14 PM
    count, date and range, dates calculation, dates difference, excel 2 Attachment(s)
    • 824
    Last Post: 03-04-2018 09:02 AM
    by anonymous321  Go to last post

    Forum:
    Excel General

  30. [SOLVED] Formula/method to sort by specific time period within date+time ranges in cell

    Started by mikeskins84‎, 02-09-2018 06:57 AM
    date and range, formula and functions 4 Attachment(s)
    • 2,323
    Last Post: 02-13-2018 01:12 PM
    by Pete_UK  Go to last post

    Forum:
    Excel Formulas & Functions

  31. [SOLVED] Loookup on multiple date range & multiple lines

    Started by BrazenBigfoot‎, 10-17-2017 09:46 PM
    date and range, index & match, multiple date range, vloockup 4 Attachment(s)
    • 1,435
    Last Post: 10-19-2017 07:26 PM
    by JBeaucaire  Go to last post

    Forum:
    Excel General

  32. Week Numbers base on Date Range

    Started by MrServer‎, 06-23-2017 06:19 PM
    date and range, formual, week numbers
    • 651
    Last Post: 06-24-2017 02:12 AM
    by MrServer  Go to last post

    Forum:
    Excel Formulas & Functions

  33. [SOLVED] Return Column title for table dates

    Started by alexgoaga‎, 06-20-2017 04:08 AM
    date and range, formula 1 Attachment(s)
    • 517
    Last Post: 06-20-2017 04:44 AM
    by alexgoaga  Go to last post

    Forum:
    Excel Formulas & Functions

  34. Help with formula - summarize dates

    Started by OBA‎, 06-14-2017 01:22 PM
    date, date and range 2 Attachment(s)
    • 607
    Last Post: 06-19-2017 02:42 PM
    by OBA  Go to last post

    Forum:
    Excel Formulas & Functions

  35. [SOLVED] Highlighting date in last 3 months

    Started by jwal29‎, 04-06-2017 11:25 AM
    cond formatting formula, date, date and range 2 Attachment(s)
    • 4,567
    Last Post: 04-11-2017 04:26 AM
    by AliGW  Go to last post

    Forum:
    Excel General

Results 1 to 35 of 63
Page 1 of 2 1 2

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1