Search:

Tag: dates calculation

Search: Replies Views Search took 0.00 seconds.

  1. [SOLVED] Problem with calculation due to ISO date format

    Started by Bluesky0094‎, 03-13-2023 02:53 PM
    dates calculation, iso8601 5 Attachment(s)
    • 305
    Last Post: 03-14-2023 09:54 AM
    by Bluesky0094  Go to last post

    Forum:
    Excel General

  2. How to count dates in the format Monday, Jan 1, 2020

    Started by 4excel‎, 09-21-2020 11:02 AM
    dates calculation, dates formula 2 Attachment(s)
    • 508
    Last Post: 09-21-2020 12:35 PM
    by korekurd  Go to last post

    Forum:
    Excel General

  3. [SOLVED] Dynamic Array Formula Query - Dates

    Started by moglij‎, 04-24-2020 06:20 AM
    dates calculation, dynamic arrays 2 Attachment(s)
    • 353
    Last Post: 04-24-2020 06:34 PM
    by moglij  Go to last post

    Forum:
    Excel Formulas & Functions

  4. Self recursive date modifier

    Started by Leon V (AW)‎, 03-18-2020 09:36 AM
    circular reference, dates calculation, recursion, recursive
    • 352
    Last Post: 03-18-2020 09:36 AM
    by Leon V (AW)  Go to last post

    Forum:
    Excel Formulas & Functions

  5. How to determine commission on sale based on percentage of sale

    Started by shanman2‎, 02-13-2020 10:14 AM
    dates calculation, sales commission 1 Attachment(s)
    • 1,222
    Last Post: 02-14-2020 11:18 AM
    by FlameRetired  Go to last post

    Forum:
    Excel General

  6. [SOLVED] Number of Hours & Minutes between two Dates & Times. 1 min. Difference

    Started by SirTypos‎, 09-29-2019 12:58 AM
    dates calculation, duration, hours, minutes 2 Attachment(s)
    • 657
    Last Post: 09-30-2019 01:10 AM
    by SirTypos  Go to last post

    Forum:
    Excel Formulas & Functions

  7. Calculating rental period and cost

    Started by JustMax‎, 02-06-2019 05:24 PM
    dates, dates calculation
    • 4,341
    Last Post: 02-07-2019 11:05 AM
    by etaf  Go to last post

    Forum:
    Excel Formulas & Functions

  8. Invoice Pay Schedule?

    Started by dogetheavenger‎, 07-05-2018 10:58 AM
    dates calculation, if statements 3 Attachment(s)
    • 600
    Last Post: 07-05-2018 12:07 PM
    by sandy666  Go to last post

    Forum:
    Excel Formulas & Functions

  9. [SOLVED] Month Function When Nested inside Text returns incorrect Month Serial Number

    Started by ibuhary‎, 05-06-2018 03:42 AM
    dates calculation, excel function help, nested formula
    • 664
    Last Post: 05-06-2018 04:12 AM
    by ibuhary  Go to last post

    Forum:
    Excel Formulas & Functions

  10. Auto-fill dates based on input in other cells

    Started by bwill225‎, 03-27-2018 11:00 AM
    auto populate cells, dates calculation 2 Attachment(s)
    • 2,551
    Last Post: 03-28-2018 07:43 AM
    by Kyle123  Go to last post

    Forum:
    Excel Formulas & Functions

  11. 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)
    • 677
    Last Post: 03-04-2018 09:02 AM
    by anonymous321  Go to last post

    Forum:
    Excel General

  12. [SOLVED] Month Count using Two Dates

    Started by nevernine9‎, 02-24-2018 11:39 AM
    count between dates, dates calculation, month
    • 605
    Last Post: 02-25-2018 11:08 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  13. [SOLVED] Revisit: Summing with date difference and conditions

    Started by ZedaG‎, 04-18-2017 08:12 AM
    #num!, dates calculation 1 Attachment(s)
    • 447
    Last Post: 04-18-2017 08:53 AM
    by ZedaG  Go to last post

    Forum:
    Excel Formulas & Functions

  14. Assistance with data validation for dates

    Started by trudiok‎, 02-25-2017 10:59 PM
    dates calculation, validation 2 Attachment(s)
    • 963
    Last Post: 03-01-2017 01:21 AM
    by FDibbins  Go to last post

    Forum:
    Excel Formulas & Functions

  15. Conditional formatting to highlight multiple date ranges in column calculating from today

    Started by JacqueM‎, 06-09-2016 10:47 AM
    conditional formatting, dates calculation, dates formating
    • 1,078
    Last Post: 06-09-2016 11:38 AM
    by Special-K  Go to last post

    Forum:
    Excel Formulas & Functions

  16. [SOLVED] Calculate Days Worked with Criteria

    Started by nickmessick1‎, 03-13-2015 04:11 PM
    array, dates calculation, macro, sumproduct 1 Attachment(s)
    • 749
    Last Post: 03-13-2015 04:53 PM
    by nickmessick1  Go to last post

    Forum:
    Excel General

  17. Resource Planning

    Started by akshay12‎, 12-16-2014 04:57 AM
    dates, dates calculation, resource allocation, resource planning 1 Attachment(s)
    • 1,004
    Last Post: 12-16-2014 04:57 AM
    by akshay12  Go to last post

    Forum:
    Excel Formulas & Functions

  18. Quick Pivot Table Help - Count and group Multiple Dates

    Started by jmcconville18‎, 10-13-2014 04:00 PM
    dates calculation, grouping, pivot table 3 Attachment(s)
    • 2,531
    Last Post: 10-15-2014 11:44 AM
    by jmcconville18  Go to last post

    Forum:
    Excel Charting & Pivots

  19. Calculating how many months are within several time periods

    Started by masonjarkoolaid‎, 04-30-2014 08:58 AM
    dates calculation, days360, overlapping dates, today formula
    • 840
    Last Post: 04-30-2014 08:58 AM
    by zbor  Go to last post

    Forum:
    Excel Formulas & Functions

  20. [SOLVED] Formula Problem: Dates in Two Cells to be Subtracted!

    Started by Antligen‎, 04-10-2014 07:08 AM
    blank cell, dates calculation, formula, less than
    • 776
    Last Post: 04-10-2014 07:37 AM
    by Antligen  Go to last post

    Forum:
    Excel - New Users/Basics

  21. [SOLVED] Having two date return number but exclude negative numbers

    Started by redjayhawk11‎, 12-18-2013 01:06 PM
    dates calculation
    • 1,017
    Last Post: 12-31-2013 06:34 AM
    by etaf  Go to last post

    Forum:
    Excel General

  22. [SOLVED] Calculate the number of winter days between two dates

    Started by evp2‎, 12-11-2013 11:14 AM
    dates calculation, durations 1 Attachment(s)
    • 3,429
    Last Post: 06-14-2014 10:41 AM
    by oeldere  Go to last post

    Forum:
    Excel Formulas & Functions

  23. [SOLVED] Auto fill dates

    Started by twrtleduck‎, 09-06-2013 03:34 PM
    autofill, dates calculation, show blank 3 Attachment(s)
    • 1,648
    Last Post: 09-09-2013 03:59 PM
    by twrtleduck  Go to last post

    Forum:
    Excel General

  24. IF and Index formulas with Dates

    Started by ehardway111‎, 08-13-2013 01:29 PM
    cascading combo boxes, dates calculation, index, index & if
    • 657
    Last Post: 08-13-2013 01:33 PM
    by Ace_XL  Go to last post

    Forum:
    Excel Formulas & Functions

  25. automatic update of birthdates including day month year on a daily basis

    Started by boostvg‎, 06-27-2013 07:58 AM
    date of birth, dates calculation, formulas
    • 759
    Last Post: 06-27-2013 08:12 AM
    by etaf  Go to last post

    Forum:
    Excel General

  26. Removing holiday from dates

    Started by grkchakri‎, 05-07-2013 12:50 AM
    dates, dates calculation
    • 576
    Last Post: 05-07-2013 01:09 AM
    by JBeaucaire  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  27. [SOLVED] Start dates in excel vba

    Started by grkchakri‎, 05-05-2013 02:56 PM
    dates, dates calculation
    • 542
    Last Post: 05-05-2013 04:20 PM
    by grkchakri  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  28. I need to calculate the # of days between a date and the end of that month. Any ideas?

    Started by dougdrex‎, 05-03-2013 12:08 PM
    dates calculation
    • 645
    Last Post: 05-03-2013 12:45 PM
    by dougdrex  Go to last post

    Forum:
    Excel Formulas & Functions

  29. [SOLVED] Formula to calculate dates accurately

    Started by Lou D‎, 03-25-2013 08:33 AM
    dates calculation, formula, schedule 1 Attachment(s)
    • 833
    Last Post: 03-25-2013 09:29 AM
    by Pete_UK  Go to last post

    Forum:
    Excel Formulas & Functions

  30. [SOLVED] SUMIFS and Date Criteria (Month Year etc...) but without helper column?

    Started by JungleJme‎, 01-16-2013 06:54 AM
    dates calculation, sumifs, sumproduct 1 Attachment(s)
    • 2,403
    Last Post: 01-16-2013 07:21 AM
    by JungleJme  Go to last post

    Forum:
    Excel Formulas & Functions

  31. Networkdays: Can this be worked out 'backwards'?

    Started by Laurence Craig‎, 11-21-2012 06:40 PM
    dates, dates calculation, networkdays, working 2 Attachment(s)
    • 1,323
    Last Post: 11-21-2012 08:20 PM
    by Laurence Craig  Go to last post

    Forum:
    Excel Formulas & Functions

  32. Macro to show ONLY Duplicates on multiple sheets, and then calculate a field based on.....

    Started by snely‎, 09-17-2012 11:18 AM
    dates calculation, duplicates macro, vba 1 Attachment(s)
    • 718
    Last Post: 09-18-2012 06:41 PM
    by snely  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  33. How to calculate date of the next DayOfWeek after given date?

    Started by newbieee‎, 11-01-2011 03:09 PM
    date, dates, dates calculation, dates comparison 3 Attachment(s)
    • 1,450
    Last Post: 11-02-2011 01:03 PM
    by newbieee  Go to last post

    Forum:
    Excel General

Results 1 to 33 of 33

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1