Excel Forum

Total days in YTD Financial year

Aye Mu

Member

Members

Forum Posts: 201

Member Since:
December 22, 2018

Offline

June 17, 2021 - 10:03 am

Hi Team,

Our financial year starts at 1st July. I have the date (Apr-21 )01/04/2021 (which will be different according to selected month).

How do I get a formula for total number of days for current financial year which is 304 days (by end of Apr-21).

Thank you.

Regards,

Aye

Lionel Baijot

Member

Members

Forum Posts: 114

Member Since:
September 9, 2020

Offline

June 17, 2021 - 3:01 pm

Hi Aye Mu,

You can have different ways of calculating this number of days. Here are two solutions.

BR,

Lionel

Aye Mu

Member

Members

Forum Posts: 201

Member Since:
December 22, 2018

Offline

June 17, 2021 - 9:00 pm

Many thanks, Lionel.

Much appreciated it.

Kind Regards,

Aye

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: Andy Kirby, Chandler Davis, Atos Franzon

Guest(s) 9

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 870

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

A.Maurizio: 202

Jessica Stewart: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

wahab tunde

Cong Le Duc

Faisal Bashir

Ivica Cvetkovski

Blaine Cox

Shankar Srinivasan

riyepa fdgf

Hannah Cave

Len Matthews

Kristine Arthy

Forum Stats:

Groups: 3

Forums: 24

Topics: 6205

Posts: 27210

Member Stats:

Guest Posters: 49

Members: 31878

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen