CookieMonster76
Board Regular
- Joined
- Apr 30, 2015
- Messages
- 195
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
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