How to return April 1 of the year following a date entered in cell D3.
Example: If date in D3 is 8/14/2032, then date to return is 4/1/2033. Currently I'm using a helper cell L2 with date 04/01/1900 to get month April and day 1st. My formula is =DATE(YEAR(D$3)+1,MONTH($L$2),DAY($L$2))
Posted May 9, 2024, 2:46 AM UTC
111