Rounding a date to next March

[CookieMonster76]

Hi

I need to round an entered date to specify which financial year it falls in.

i.e. An entry of 31 July 2019 needs to be rounded up so is shows as 31 March 2020.

Happy to have the date entered in one cell (say A1) and the year end date in another say (B1).

Is this possible?

Thanks

Paul

 

[Fluff]

How about
=DATE(YEAR(A1)+IF(MONTH(A1)>3,1,0),3,31)

 

[CookieMonster76]

Perfect, thank you so much

 

[Fluff]

You're welcome & thanks for the feedback.