Excel April prior to a date

microsoft-excel

Solution 1:

Try the formula below on cell B1:

=IF(MONTH(A1)>=4,DATE(YEAR(A1),4,1),DATE(YEAR(A1)-1,4,1))

Drag it down to fill the other cells.

Results

Related

Deleting entire lines in a text file based on a partial string match with Windows PowerShell
How to increase number of devices on a mobile hotspot?
Force wrapping the long output lines that aren't so in terminal
How do I control the order in which NetworkManager brings up connections?
How do I add only certain columns to a tensor in tensorflow?
Spawn fake player with Minecraft
Dynamic Meta for Nuxt.js
TensorFlow layer subclass input shape
Flutter and Firebase Authentication: How to login anonymously only once per user/IP address
How to write a tfrecord file and read it? The error is: truncated record at 0' failed with Read less bytes than requested [Op:IteratorGetNext]
Can I get the file names for synced text files in my pipeline in Foundry?
Angular setup test weird output