How to return April 1 of the year following a date entered in cell D3.

unsolved

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

Comments aren't archived yet

This post had 11 comments on Reddit. Comments for this period haven't been loaded into the archive yet.