Good morning all.....
Done a lot of looking and have made some progress but stuck now....
My fiscal year does not always start on the same date....This is for some accounting reason...but it's been this way forever as far as i know...
What i do know is that the fiscal year starts on the SUNDAY before the LAST WEDNESDAY in MARCH...
=DATE(YEAR(B3),MONTH(B3)+1,0)+MOD(-WEEKDAY(DATE(YEAR(B3),MONTH(B3)+1,0),2)-2,-7)-5
This returns the Sunday before the Last Wednesday of each month....
I managed to get this far (with a lot of research) but cant get further....
I have a list of dates for 10 years in column B....would love to add to Column C what the FY starting date for that date is.....
In 2017...The last Wednesday in March was the 29th...the prior Sunday is the 26th...That is my FY start date
In 2018...The last Wednesday in March was the 28th...the prior Sunday is the 25th...That is my FY start date
I would love to be able to have any given date in Col. B with that date's FY Start date in order to calulate fiscal days, weeks and quarters...
Any helps would be appreciated....
Done a lot of looking and have made some progress but stuck now....
My fiscal year does not always start on the same date....This is for some accounting reason...but it's been this way forever as far as i know...
What i do know is that the fiscal year starts on the SUNDAY before the LAST WEDNESDAY in MARCH...
=DATE(YEAR(B3),MONTH(B3)+1,0)+MOD(-WEEKDAY(DATE(YEAR(B3),MONTH(B3)+1,0),2)-2,-7)-5
This returns the Sunday before the Last Wednesday of each month....
I managed to get this far (with a lot of research) but cant get further....
I have a list of dates for 10 years in column B....would love to add to Column C what the FY starting date for that date is.....
In 2017...The last Wednesday in March was the 29th...the prior Sunday is the 26th...That is my FY start date
In 2018...The last Wednesday in March was the 28th...the prior Sunday is the 25th...That is my FY start date
I would love to be able to have any given date in Col. B with that date's FY Start date in order to calulate fiscal days, weeks and quarters...
Any helps would be appreciated....