#1
|
|||
|
|||
YTD sum based on selection of month - financial year April to March
Dear Team,
Need your help to do YTD sum based on selection of month in financial year (April to March) i.e. if selected June month, sum should be from April to June, if selected October month, sum should be from April to October, if selected February month, sum should be from April to Feb. Demo file is attached for your reference. Thanks in advance |
#2
|
||||
|
||||
Hi and welcome. One of many ways attached
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Thanks a lot Pecoflyer. Literally I was struggling to get the result and you made my life easy.
|
#4
|
||||
|
||||
You're welcome. Would have appreciated some rep, though...
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula to find Month and Day but excluding the year in a date | Marcia | Excel | 5 | 08-27-2022 06:23 AM |
Calculate total services of an employee by year, month and days | Marcia | Excel | 2 | 03-07-2022 01:58 AM |
Word field last month not working within year change | eduzs | Word VBA | 4 | 07-25-2019 04:31 PM |
Empty date cell shows wrong month & year | Learner7 | Excel | 3 | 06-16-2019 11:09 AM |
Excel day date month year Function | greginky | Excel | 1 | 01-05-2016 02:19 AM |